python修改csv文件字段顺序_Pandas中DataFrame交换列顺序的方法实现

一、获取DataFrame列标签

import pandas as pd

file_path = '/Users/Arithmetic/da-rnn-master/data/collectd67_power_after_test_smooth.csv'

dataset = pd.read_csv(file_path)

cols = list(dataset)

['ps_state-stopped', 'ps_state-running', 'ps_state-blocked', 'ps_state-paging', 'ps_state-sleeping', 'ps_state-zombies', 'fork_rate', 'cpu-2-system', 'cpu-2-nice', 'cpu-2-steal',...]

二、改变列标签为指定顺序

import pandas as pd

file_path = '/Users/Arithmetic/da-rnn-master/data/collectd67_power_after_test_smooth.csv'

dataset = pd.read_csv(file_path)

cols = list(dataset)

print(cols)

cols.insert(0, cols.pop(cols.index('ps_state-running')))

print(cols)

这里改变第一列和第二列的位置顺序，用到了python list中的两个方法

insert方法：

1.功能