<jupyter_start><jupyter_text>Definitions<jupyter_code># read, and create an identifier for each course  
def set_course_name(file_path, course_name):
    course_data = pd.read_csv(file_path, header='infer')
    course_data["Course Name"] = course_name
    print(course_data.tail(2))
    return course_data
def merging_df(dataframes_list):
    merged_df = pd.concat(dataframes_list)
    print(merged_df.shape)
    print(merged_df.tail(10))
    return merged_df<jupyter_output><empty_output><jupyter_text>Import information  Math Course<jupyter_code>math_data = set_course_name("./_data/math_course_data.csv", "Math")<jupyter_output>Student Name   Student Contact  Grade Course Name
2         Mark    <EMAIL>     90        Math
3        Shane   <EMAIL>     87        Math<jupyter_text>Biology Course<jupyter_code>biology_data = set_course_name("./_data/biology_course_data.csv", "Biology")<jupyter_output>Student Name   Student Contact  Grade Course Name
2         Mark    <EMAIL>     90     Biology
3        Shane   <EMAIL>     95     Biology<jupyter_text>Chemistry Course<jupyter_code>chemistry_data = set_course_name("./_data/chemistry_course_data.csv", "Chemistry")<jupyter_output>Student Name   Student Contact  Grade Course Name
2         Mark    <EMAIL>     58   Chemistry
3        Shane   <EMAIL>     74   Chemistry<jupyter_text>Merging Sessions Information<jupyter_code>courses = [math_data, biology_data, chemistry_data]
merged_info = merging_df(courses)<jupyter_output>(12, 4)
  Student Name     Student Contact  Grade Course Name
2         Mark      <EMAIL>     90        Math
3        Shane     <EMAIL>     87        Math
0            Al       <EMAIL>     90     Biology
1       Dominic  <EMAIL>     90     Biology
2         Mark      <EMAIL>     90     Biology
3        Shane     <EMAIL>     95     Biology
0            Al       <EMAIL>     80   Chemistry
1       Dominic  <EMAIL>     56   Chemistry
2         Mark      <EMAIL>     58   Chemistry
3        Shane     <EMAIL>     74   Chemistry<jupyter_text>Exporting Data<jupyter_code>merged_info .to_csv(path_or_buf='./_output/0_unified_courses_data.csv', index=False)<jupyter_output><empty_output>
StarcoderdataJupyterStructuredCleanDedup