pandas数据处理添加列

1、创建df

import pandas as pd
Name =  ['John Lee','Peter Chan', 'Janice Ma','Roy Kwok', 'Peter Ng','Joe Lam','Bill Kwan','Christine Law','Ricky Chan','Theresa Mak','Chole Wu','Isaac Lee','Gina Wut','Candy Ip','Ben Chan','Anson Lo','Jacky Shiu','Catherine Wo','Elton Tang','Rock Shek']
l1 = []
l2 = []
l3 = []
l4 = []
for i in range(20):
    l1.append(0)
    l2.append(0)
    l3.append(0)
    l4.append(0)
data = {
    'HW1': l1,
    'HW2': l2,
    'Test': l3,
    'Exam': l4
}

results = pd.DataFrame(data, index=Name)
print(results)

2、更新数据

ll1 = [81,71,99,52,42,76,71,31,69,39,68,34,43,95,81,34,100,65,74,31]
ll2 = [88,49,36,65,34,61,44,100,86,85,57,93,65,87,99,71,73,96,63,85]
ll3 = [98,54,32,63,98,54,56,33,51,90,61,89,48,90,39,79,74,49,73,52]
ll4 = [38,54,100,86,92,64,88,72,82,55,74,93,64,81,41,36,98,56,79,37]
data1 = {
    'HW1': ll1,
    'HW2': ll2,
    'Test': ll3,
    'Exam': ll4
}
new_data = pd.DataFrame(data1, index=Name)

results.update(new_data)
print(results)

3、添加新列

results['total'] = results.apply(lambda x: x[0]*0.2+x[1]*0.2+x[2]*0.2+x[3]*0.4, axis=1)
print(results)

4、再添加新列

results['Grade'] = results.apply(lambda x: 'F' if x[4]<= 49 else ('D' if x[4] <= 59 and x[4] >= 50 else ('C' if x[4]>= 60 and x[4] <= 69 else ('B' if x[4] >= 70 and x[4] <= 79 else 'A'))), axis=1)
print(results)