python CSV操作

import csv
import pandas as pd

person = [
    ('黄海平', 18, 180), ('刘德华', 40, 175), ('黎明', 40, 180)
]
# 表头
header = ('name', 'age', 'height')
# w--> 写
# 如果用office打开乱码 utf-o-sig      writerows写入多行
# with open('person.csv', 'w', encoding='utf-8-sig') as f:
#     writer = csv.writer(f)
#     writer.writerow(header)
#     for i in person:
#         writer.writerow(i)


# 第二种写入方式   以字典方式写入
persons = [
    {'name': 'xxxx', 'age': 18, 'height': 180},
    {'name': 'xxxx', 'age': 18, 'height': 180},
    {'name': 'xxxx', 'age': 18, 'height': 180},
    {'name': 'xxxx', 'age': 18, 'height': 180},
    {'name': 'xxxx', 'age': 18, 'height': 180},
]
# newline:是否换行
# with open('dict_person.csv', 'w', encoding='utf-8-sig', newline='') as f:
#     DictWrite = csv.DictWriter(f, header)
#     # 写入表头
#     DictWrite.writeheader()
#     # 多行写入
#     DictWrite.writerows(persons)

# 第一种读取文件方式
# with open('dict_person.csv', 'r', encoding='utf-8-sig') as f:
#     r = csv.reader(f)
    # print(f.readlines())
    # for i in r:
    #     print(i)

# 第二种读取方式
with open('dict_person.csv', 'r', encoding='utf-8-sig') as f:
    r = csv.DictReader(f)
    for i in r:
        print(i)

data = pd.read_csv("dict_person.csv")
print(data)


datas = pd.read_csv('豆瓣电影数据.csv')
print(datas)