-
Notifications
You must be signed in to change notification settings - Fork 1
/
merge_csv.py
24 lines (18 loc) · 793 Bytes
/
merge_csv.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
import pandas as pd
def merge_csv(csv1, csv2):
csv1["ID number"] = csv1["ID number"].astype("Int64")
csv2["ID number"] = csv2["ID number"].astype("Int64")
df = pd.merge(csv1, csv2, on=["First name", "Surname", "ID number"])
df["ID number"] = df["ID number"].astype("Int64")
return df
def merge_feedback_columns(df, columns):
feedback_x, feedback_y = columns
df["Feedback"] = df[feedback_x].map(str) + " And " + df[feedback_y].map(str)
df = df.drop(feedback_x, axis=1)
df = df.drop(feedback_y, axis=1)
return df
data1 = pd.read_csv("FinalGrades.csv")
data2 = pd.read_csv("FinalGrades1.csv")
output = merge_csv(data1, data2)
output = merge_feedback_columns(output, ["Feedback_x", "Feedback_y"])
output.to_csv("Final_grades_merged.csv", index=False)