pandas读取和写入CVS数据

1、pandas读取和写入CVS数据

import pandas as pd

#1.读取***01.csv   筛选按指定列顺序排列数据
df = pd.read_csv('E:\\***01.csv',delimiter=',',encoding="gbk",usecols=['country','third_category','revenue','units']) [['country','third_category','revenue','units']]     #usecols使用部分列  [['country','third_category','revenue','units']] 筛选指定列顺序


# 2.将指定列读取的数据保存***02.csv中
df.to_csv('E:\\***02.csv')

# 3.读取***02.csv数据
df = pd.read_csv('E:\\***02.csv',delimiter=',',encoding="utf-8")
print(df.to_string())

2、pandas追加写入CVS数据

import pandas as pd

# 1.读取***02.csv数据
df1 = pd.read_csv('E:\\***02.csv',delimiter=',',encoding="utf-8")
print(df.to_string())


#2.求'revenue'和'units'最大值
df1['revenue'].max()
df1['units'].max()
print(df1)

#3.追加写入数据到***02.csv中
df2.to_csv('E:\\***02.csv',mode = 'a',dtype=float)