首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >你能阻止df.append()的自动字母顺序吗?

问你能阻止df.append()的自动字母顺序吗?
EN

Stack Overflow用户
提问于 2015-01-02 22:18:23
回答 3查看 6.7K关注 0票数 8

我试图将数据附加到日志中,在日志中列的顺序不是按字母顺序排列的,而是有逻辑意义的,例如。

代码语言:javascript
复制
Org_Goals_1  Calc_Goals_1  Diff_Goals_1   Org_Goals_2 Calc_Goals_2 Diff_Goals_2 

我正在根据不同的变量运行几个计算,并在每次运行后附加一个值字典来记录结果。是否有一种方法可以防止df.append()函数按字母顺序排列列?

EN

回答 3

Stack Overflow用户

回答已采纳

发布于 2015-01-02 22:56:53

似乎您必须在追加操作之后重新排序列:

代码语言:javascript
复制
In [25]:
# assign the appended dfs to merged
merged = df1.append(df2)
# create a list of the columns in the order you desire
cols = list(df1) + list(df2)
# assign directly
merged.columns = cols
# column order is now as desired
merged.columns
Out[25]:
Index(['Org_Goals_1', 'Calc_Goals_1', 'Diff_Goals_1', 'Org_Goals_2', 'Calc_Goals_2', 'Diff_Goals_2'], dtype='object')

示例:

代码语言:javascript
复制
In [26]:

df1 = pd.DataFrame(columns=['Org_Goals_1','Calc_Goals_1','Diff_Goals_1'], data = randn(5,3))
df2 = pd.DataFrame(columns=['Org_Goals_2','Calc_Goals_2','Diff_Goals_2'], data=randn(5,3))
merged = df1.append(df2)
cols = list(df1) + list(df2)
merged.columns = cols
merged
Out[26]:
   Org_Goals_1  Calc_Goals_1  Diff_Goals_1  Org_Goals_2  Calc_Goals_2  \
0     0.028935           NaN     -0.687143          NaN      1.528579   
1     0.943432           NaN     -2.055357          NaN     -0.720132   
2     0.035234           NaN      0.020756          NaN      1.556319   
3     1.447863           NaN      0.847496          NaN     -1.458852   
4     0.132337           NaN     -0.255578          NaN     -0.222660   
0          NaN      0.131085           NaN     0.850022           NaN   
1          NaN     -1.942110           NaN     0.672965           NaN   
2          NaN      0.944052           NaN     1.274509           NaN   
3          NaN     -1.796448           NaN     0.130338           NaN   
4          NaN      0.961545           NaN    -0.741825           NaN   

   Diff_Goals_2  
0           NaN  
1           NaN  
2           NaN  
3           NaN  
4           NaN  
0      0.727619  
1      0.022209  
2     -0.350757  
3      1.116637  
4      1.947526  

同样的列的alpha排序也与concat一起进行,因此看起来您必须在追加后重新排序。

编辑

另一种选择是使用join

代码语言:javascript
复制
In [32]:

df1.join(df2)
Out[32]:
   Org_Goals_1  Calc_Goals_1  Diff_Goals_1  Org_Goals_2  Calc_Goals_2  \
0     0.163745      1.608398      0.876040     0.651063      0.371263   
1    -1.762973     -0.471050     -0.206376     1.323191      0.623045   
2     0.166269      1.021835     -0.119982     1.005159     -0.831738   
3    -0.400197      0.567782     -1.581803     0.417112      0.188023   
4    -1.443269     -0.001080      0.804195     0.480510     -0.660761   

   Diff_Goals_2  
0     -2.723280  
1      2.463258  
2      0.147251  
3      2.328377  
4     -0.248114  
票数 4
EN

Stack Overflow用户

发布于 2015-01-03 00:18:07

实际上,我发现“高级索引”工作得很好。

代码语言:javascript
复制
df2=df.ix[:,'order of columns']
票数 4
EN

Stack Overflow用户

发布于 2016-09-08 10:22:49

在我看来,订单丢失了,但是当附加时,原始数据应该有正确的顺序。为了保持这一点,假设Dataframe 'alldata‘和dataframe被追加数据'newdata',并按照'alldata’中的列顺序追加和保持列顺序,则如下所示:

代码语言:javascript
复制
alldata.append(newdata)[list(alldata)]

(我在命名日期字段中遇到了这个问题,其中“月份”将在“分钟”和“第二”之间排序)

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/27749276

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档