dataframe增加列数据，题目详情见正文

热线电话：13121318867

yuechuchen

2020-04-30 阅读量: 4465

df表如下：

请为df表添加一列“基本工资”，实现效果如下：

参考代码：

list1 = [["第一分公司","第二分公司",]
         ,["销售部","市场部","行政部"]]
index = pd.MultiIndex.from_product(list1, names=['公司', '部门'])
df = pd.DataFrame({"姓名":["Allen","Lucy","Tom","Alice","Tim","Lily"],"工龄":np.random.randint(1,5,6)
                  ,"入职日期":["2017-01-30","#","2019-07-21","2020-04-02","-","2017-05-12"]},index = index)
df
ser1 = pd.Series(np.random.randint(2500,5000,6),name = "基本工资",index=index)
df.join(ser1)

代码结果：