熊貓將列表分成多列我有一個熊貓數(shù)據(jù)框架，列如下所示：`In [207]:df2.teamsOut[207]: 0 [SF, NYG]1 [SF, NYG]2 [SF, NYG]3 [SF, NYG]4 [SF, NYG]5 [SF, NYG]6 [SF, NYG]7 [SF, NYG]`我需要使用熊貓將這一列表分成兩個列，分別命名為第1組和第2組。
3 回答
叮當(dāng)貓咪
TA貢獻(xiàn)1776條經(jīng)驗 獲得超12個贊
DataFramelistsnumpy arrayvaluestolist:
import pandas as pd
d1 = {'teams': [['SF', 'NYG'],['SF', 'NYG'],['SF', 'NYG'],
['SF', 'NYG'],['SF', 'NYG'],['SF', 'NYG'],['SF', 'NYG']]}df2 = pd.DataFrame(d1)print (df2)
teams0 [SF, NYG]1 [SF, NYG]2 [SF, NYG]3 [SF, NYG]4 [SF, NYG]5 [SF, NYG]6 [SF, NYG]df2[['team1','team2']] = pd.DataFrame(df2.teams.values.tolist(), index= df2.index)print (df2) teams team1 team20 [SF, NYG] SF NYG1 [SF, NYG] SF NYG2 [SF, NYG] SF NYG3 [SF, NYG] SF NYG4 [SF, NYG] SF NYG5 [SF, NYG] SF NYG6 [SF, NYG] SF NYG
DataFrame:
df3 = pd.DataFrame(df2['teams'].values.tolist(), columns=['team1','team2'])print (df3) team1 team20 SF NYG1 SF NYG2 SF NYG3 SF NYG4 SF NYG5 SF NYG6 SF NYG
apply(pd.Series)
#7k rowsdf2 = pd.concat([df2]*1000).reset_index(drop=True)In [89]: %timeit df2['teams'].apply(pd.Series)1 loop, best of 3: 1.15 s per loopIn [90]: %timeit pd.DataFrame(df2['teams'].values.tolist(), columns=['team1','team2'])1000 loops, best of 3: 820 μs per loop
函數(shù)式編程
TA貢獻(xiàn)1807條經(jīng)驗 獲得超9個贊
pd.DataFrame(df2.teams.tolist(), columns=['team1', 'team2'])
team1 team2-------------0 SF NYG1 SF NYG2 SF NYG3 SF NYG4 SF NYG5 SF NYG6 SF NYG7 SF NYG
pd.DataFrame(df.teams.str.split('<delim>', expand=True).values,
columns=['team1', 'team2'])
大話西游666
TA貢獻(xiàn)1817條經(jīng)驗 獲得超14個贊
df2 = pd.DataFrame(df['meta'].str.split().values.tolist())
添加回答
舉報
0/150
提交
取消