pandas操纵csv

1. 读取csv

import pandas as pd

# sep分隔符,默认为','
df = pd.read_csv('student_scores.csv', sep=',')

# 添加列标签
labels = ['id', 'name', 'attendance', 'hw', 'test1', 'project1', 'test2', 'project2', 'final']
df = pd.read_csv('student_scores.csv', names=labels)

# header=None，防止数据的第一行被误当做列标签
# header=0，使用第一行作为列标签

2. 存入csv

import pandas as pd

data = pd.DataFrame([(author, publish, pubyear, fixprice, ISBN)])
# 设置encoding="utf-8-sig"可避免excel打开csv乱码，mode='a+'为追加模式
data.to_csv('info.csv', header=False, index=False, mode='a+', encoding="utf-8-sig")

3. 合并csv

• 法一：pd.concat( )

import