如何更改 pandas dataframe 中两列的位置
作者:weixin_33830216 时间:2023-01-06 03:14:23
如何更改 pandas dataframe 中两列的位置:
把其中的某列移到第一列的位置。
原来的 df 是:
df = pd.read_csv('I:/Papers/consumer/codeandpaper/TmallData/result01.csv')
Net Upper Lower Mid Zsore
Answer option
More than once a day 0% 0.22% -0.12% 2 65
Once a day 0% 0.32% -0.19% 3 45
Several times a week 2% 2.45% 1.10% 4 78
Once a week 1% 1.63% -0.40% 6 65
要将 Mid 这一列移动到第一列?
Mid Upper Lower Net Zsore
Answer option
More than once a day 2 0.22% -0.12% 0% 65
Once a day 3 0.32% -0.19% 0% 45
Several times a week 4 2.45% 1.10% 2% 78
Once a week 6 1.63% -0.40% 1% 65
解决办法:(使用 ix )
法一:
In [27]:
# get a list of columns
cols = list(df)
# move the column to head of list using index, pop and insert
cols.insert(0, cols.pop(cols.index('Mid')))
cols
Out[27]:
['Mid', 'Net', 'Upper', 'Lower', 'Zsore']
In [28]:
# use ix to reorder
df = df.ix[:, cols]
df
Out[28]:
Mid Net Upper Lower Zsore
Answer_option
More_than_once_a_day 2 0% 0.22% -0.12% 65
Once_a_day 3 0% 0.32% -0.19% 45
Several_times_a_week 4 2% 2.45% 1.10% 78
Once_a_week 6 1% 1.63% -0.40% 65
法二:
In [39]:
mid = df['Mid']
df.drop(labels=['Mid'], axis=1,inplace = True)
df.insert(0, 'Mid', mid)
df
Out[39]:
Mid Net Upper Lower Zsore
Answer_option
More_than_once_a_day 2 0% 0.22% -0.12% 65
Once_a_day 3 0% 0.32% -0.19% 45
Several_times_a_week 4 2% 2.45% 1.10% 78
Once_a_week 6 1% 1.63% -0.40% 65
#### full data
df = pd.read_csv('I:/Papers/consumer/codeandpaper/TmallData/result01.csv')
def func(x):
return str(x['time_stamp'])+str(x['user_id'])
df['session_id'] = df.apply(func, axis=1)
del df['time_stamp']
sessionID=df['session_id']
df.drop(labels=['session_id'],axis=1,inplace=True)
df.insert(0,'session_id',sessionID)
df.to_csv('I:/Papers/consumer/codeandpaper/TmallData/result02.csv')
最终的处理结果:
来源:https://blog.csdn.net/weixin_33830216/article/details/85968282
标签:pandas,dataframe,列位置
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
ActiveMQ:使用Python访问ActiveMQ的方法
2022-04-19 01:48:30
![](https://img.aspxhome.com/file/2023/8/110038_0s.jpg)
python opencv画局部放大图实例教程
2023-12-01 09:55:55
![](https://img.aspxhome.com/file/2023/9/93999_0s.jpg)
VSCode的使用配置以及VSCode插件的安装教程详解
2023-05-31 14:48:46
![](https://img.aspxhome.com/file/2023/3/130893_0s.png)
Python正则表达式之基础篇
2021-06-17 13:10:45
![](https://img.aspxhome.com/file/2023/7/131497_0s.png)
golang执行命令获取执行结果状态(推荐)
2024-04-30 10:05:00
CSS样式表中继承关系的空格与不空格
2007-12-12 13:05:00
python3 面向对象__类的内置属性与方法的实例代码
2023-03-24 10:03:19
微信小程序 scroll-view实现上拉加载与下拉刷新的实例
2024-04-23 09:30:40
![](https://img.aspxhome.com/file/2023/7/135487_0s.gif)
解决Vue不能检测数组或对象变动的问题
2024-04-27 15:59:40
Python txt文件常用读写操作代码实例
2021-08-22 04:38:28
深入mysql主从复制延迟问题的详解
2024-01-26 09:55:11
php+jQuery实现的三 级导航栏下拉菜单显示效果
2023-11-14 12:32:05
![](https://img.aspxhome.com/file/2023/1/55601_0s.jpg)
Linux安装Python3如何和系统自带的Python2并存
2023-08-25 03:42:09
进一步了解Python中的XML 工具
2022-06-25 21:49:17
详解vue的diff算法原理
2023-07-02 16:49:44
![](https://img.aspxhome.com/file/2023/2/139792_0s.png)
用mysqldump备份和恢复指定表的方法
2024-01-17 13:37:00
一步步教你配置MySQL远程访问
2024-01-16 13:07:26
![](https://img.aspxhome.com/file/2023/1/68061_0s.png)
python pandas中对Series数据进行轴向连接的实例
2022-08-07 11:52:21
oracle中存储函数与存储过程的区别介绍
2023-07-12 23:40:15
python学习数据结构实例代码
2023-09-20 22:56:32