CSV数据处理

CSV是一种一行中使用逗号分隔的数据表格格式

数据读取

直接读取

# 打开文件并读取 得到字符串
file = open("name.csv","r")
data = file.read()
# 切分成行
data_line = data.split("\n")
data_conp = []
# 每一行划分成list
for line in data_line:
    data_conp.append(line.split(","))

使用csv包读取

# 导入CSV库
import csv
file = open("name.csv","r")
# 获得reader对象
reader = csv.reader(file)
# 每次调用返回一行数据
headline = next(reader)
# 返回所有数据<list of list>
data = list(reader)

通常情况下,数据表格中含有表头,需单独处理

# 直接读取数据时要去掉表头
raw_data = list(reader)
header = raw_data[0]
data = raw_data[1:]
for index, item in enumerate(header):
  print(index.item)
Lei Yang
Lei Yang
PhD candidate

My research interests include visual speech recognition and semantics segmentation.