python csv文件读取

#按行进行读取的
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)