我试图将数据附加到日志中,在日志中列的顺序不是按字母顺序排列的,而是有逻辑意义的,例如。
Org_Goals_1 Calc_Goals_1 Diff_Goals_1 Org_Goals_2 Calc_Goals_2 Diff_Goals_2 我正在根据不同的变量运行几个计算,并在每次运行后附加一个值字典来记录结果。是否有一种方法可以防止df.append()函数按字母顺序排列列?
发布于 2015-01-02 22:56:53
似乎您必须在追加操作之后重新排序列:
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')示例:
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
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 发布于 2015-01-03 00:18:07
实际上,我发现“高级索引”工作得很好。
df2=df.ix[:,'order of columns']发布于 2016-09-08 10:22:49
在我看来,订单丢失了,但是当附加时,原始数据应该有正确的顺序。为了保持这一点,假设Dataframe 'alldata‘和dataframe被追加数据'newdata',并按照'alldata’中的列顺序追加和保持列顺序,则如下所示:
alldata.append(newdata)[list(alldata)](我在命名日期字段中遇到了这个问题,其中“月份”将在“分钟”和“第二”之间排序)
https://stackoverflow.com/questions/27749276
复制相似问题