import pandas as pd
def demo(raw_data,origin):
df = pd.DataFrame(raw_data,index=origin)
#转换成编程要求所示DataFrame, 并输出
#********** Begin **********#
df = df.reset_index()
df.columns = ['name', 'age', 'gender', 'department']
df['id'] = range(1, len(df) + 1)
df = df[['id', 'name', 'age', 'gender', 'department']]
print(df)
#********** End **********#
return
# 测试代码
raw_data = [('张三', 20, '男', '计算机系'), ('李四', 21, '女', '电子系'), ('王五', 22, '男', '自动化系')]
origin = ['A', 'B', 'C']
demo(raw_data, origin)