2021-05-17

txt 文件的读写

import pandas as pd

data_txt = pd.read_table("data.txt", header=None, encoding="utf-8", sep="	")

# 参数解读: header 去除index 和 counum 
# encoding 编码
# sep = ","  和print中sep道理一样

print(data_txt)

CSV文件的读取 

# -*- coding: UTF-8 -*-

import pandas as pd
import csv

def write_to_csv(): df = pd.DataFrame( {'province': ['北京', '上海', '广东', '江苏', '四川'], 'city': ['北京', '上海', '广州', '南京', '成都'], 'economic': [1, 2, 3, 4, 5], 'populations': [1, 2, 33, 4, 5] } )  #创建二维数组,不给定index,默认12345 try: df.to_csv('./File/csvFile.csv',encoding='utf-8-sig')  #注意添加编码，不然乱码 except: pass else: print("文件存入成功！")

def read_csv(): df = pd.read_csv("./File/csvFile.csv") print(df.head(2)) #这里的操作就是DF的操作了

if __name__ == "__main__": # write_to_csv() read_csv()