pythoncsv文件读取

#按行进行读取的 import numpy as np import csv # 通过csv读取文件 csvRead = csv.reader(open('C:\\Users\\Rachel\\Desktop\\CR\\raw_data.csv','r')) # 打开写入文件的窗口 csvWrite = open('C:\\Users\\Rachel\\Desktop\\CR\\dataresult.csv','w') for linelist in csvRead: #print(linelist) data0 =linelist[0] for i in range(1,len(linelist)): if linelist[i]!="" : if ":" in linelist[i]:                 #写入文件                 csvWrite.write(data0+","+linelist[i]+"\n") #result.append(data0+","+linelist[i])

pandas 读取文件，按列进行处理文件内容

import pandas as pd # data = pd.read_csv("E:\\working\\2018_5_9\\data\\Cl_data\\grids.csv",header = None) data = pd.read_excel("E:\\working\\2018_5_9\\data\\Cl_data\\grids.xlsx",header = None) data1 = data[data[0]<60000] data1.to_excel("data1.xlsx",index = False) data2 = data[(data[0]>= 60000) & (data[0] <120000) ] data2.to_excel("data2.xlsx",index = False) data3= data[data[0]>=120000] data3.to_excel('data3.xlsx',index = False)