首页 > 编程语言 > 详细

[Python Cookbook]Pandas: How to increase columns for DataFrame?Join/Concat

时间:2020-02-28 10:27:00      阅读:59      评论:0      收藏:0      [点我收藏+]

 

1. Combine Two Series

series1=pd.Series([1,2,3],name=s1)
series2=pd.Series([4,5,6],name=s2)
df = pd.concat([series1, series2], axis=1)

Out:

技术分享图片

series1=pd.Series([1,2,3],index=[a,b,c],name=s1)
series2=pd.Series([4,5,6],index=[a,b,d],name=s2)
df = pd.concat([series1, series2], axis=1)

Out:

技术分享图片

 

 

 Note: Two series must have names.

 

2. Add a series to a data frame

df=pd.DataFrame([1,2,3],index=[a,b,c],columns=[s1])
s2=pd.Series([4,5,6],index=[a,b,d],name=s2)
df[s2]=s2

Out:

技术分享图片

 

This method is equivalant to left join:

d2.join(s2,how=left,inplace=True)

To get the same result as Part 1, we can use outer join:

d2.join(s2,how=outer,inplace=True)

 

[Python Cookbook]Pandas: How to increase columns for DataFrame?Join/Concat

原文:https://www.cnblogs.com/sherrydatascience/p/12375589.html

(1)
(1)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!