python中读取csv文件 python怎么读取csv文件
python\u4e2d\u600e\u6837\u8bfb\u53d6csv\u6587\u4ef6\u5185\u5bb9\u548c\u666e\u901a\u6587\u4ef6\u4e00\u6837\u8bfb\u53d6\u3002csv\u4e2d\u6587\u4ef6\u6570\u636e\u9879\u6709\u9017\u53f7\u5212\u5206\u5f00\u3002
infile = open("data.csv", 'r')for line in infile: data = line.rstrip().split(',') print(data)
csv\u6587\u4ef6\u5c31\u662f\u7528\u9017\u53f7\u5206\u9694\u7684\u6587\u672c\u6587\u4ef6\uff0c\u548c\u6587\u672c\u6587\u4ef6\u7684\u8bfb\u53d6\u65b9\u5f0f\u76f8\u540c\u3002
\u5982\u679ccsv\u6587\u4ef6\u90fd\u662f\u6570\u503c\uff0c\u60f3\u8981\u5c06\u5176\u8f6c\u4e3a\u5217\u8868\uff0c\u53ef\u91c7\u7528\u5982\u4e0b\u7a0b\u5e8f\u5b9e\u73b0\uff1a
# csv_file
f=open('abc.txt','r')
lines=f.readlines()
print(lines)
f.close()
list1=[]
for line in lines:
for i in line.split(','):
list1.append(int(i))
print(list1)
第一种，普通方法读取（open函数打开，然后使用for循环读取内容）；
第二种，使用用CSV标准库读取；
第三种，用pandas模块读取。
绛旓細1銆佹墦寮鐢佃剳锛岀偣鍑昏繘鍏ython锛屾病鏈変笅杞界殑鍙互鍘诲畼缃戜笅杞姐2銆佽繘鍏ヤ箣鍚庢壘鍒癈SV妯℃澘骞跺鍏锛岀劧鍚庡垱寤轰竴涓狢SV鏂囦欢瀵硅薄銆3銆佷娇鐢╫pen鍑芥暟鎵撳紑csv鏂囦欢锛岀偣鍑昏繍琛屽嵆鍙畬鎴愩備粖澶╃殑鍒嗕韩灏辨槸杩欎簺锛屽笇鏈涜兘甯姪澶у銆
绛旓細Python璇诲彇CSV鏂囦欢鏂规硶濡備笅锛氬涓嬫槸涓涓狢VS鏂囦欢 浣跨敤Python鎵撳紑CSV鍙互鐩存帴浣跨敤open鍑芥暟鎵撳紑锛岀劧鍚庝娇鐢╮eader鍑芥暟璇诲彇鍐呭锛屽疄鐜颁唬鐮佸涓嬶細杩愯缁撴灉濡備笅锛氭洿澶歅ython鐩稿叧鎶鏈枃绔狅紝璇疯闂甈ython鏁欑▼鏍忕洰杩涜瀛︿範锛佷互涓婂氨鏄皬缂栧垎浜殑鍏充簬python涓庝箞璇诲彇csv鏂囦欢鐨勮缁嗗唴瀹瑰笇鏈涘澶у鏈夋墍甯姪锛屾洿澶氭湁鍏硃ython鏁欑▼璇峰叧...
绛旓細python璇诲彇csv鏂囦欢 绗竴姝ヨ緭鍏モ import csv reader = csv.reader(open('d://2.csv')) for list in reader: print(list) 鈥濅唬鐮侊紝璇诲彇d鐩樼殑2.csv鏂囦欢锛屽涓嬪浘鎵绀猴細绗簩姝ヨ繍琛宲y鏂囦欢锛屽彲浠ョ湅鍒拌鍙栦簡csv鏂囦欢鍐呭锛岃繖閲岄渶瑕佹敞鎰忕殑鏄鏋滅洿鎺ュ皢excel琛ㄦ牸鍚庣紑鍚嶆敼涓篶sv鏂囦欢锛岃鍙栫殑鏃跺欙紝浼氬嚭鐜扮紪鐮...
绛旓細涓嬮潰鏄竴涓畝鍗曠殑 Python 璇诲彇 CSV 鏂囦欢鐨勪緥瀛愶細bashCopy codeimport pandas as pd# 璇诲彇 CSV 鏂囦欢df = pd.read_csv('test.csv')# 棰勮鏁版嵁print(df.head())# 鏁版嵁娓呮礂鍜岄澶勭悊df = df.dropna() # 鍒犻櫎缂哄け鍊糳f = df.drop_duplicates() # 鍒犻櫎閲嶅鍊# 缁熻鍒嗘瀽鍜屽彲瑙嗗寲print(df.de...
绛旓細杩欎袱澶╁垰濂界湅鍒帮紝Python CookBook涓婃湁璇村埌銆傝繖閲屾槸涓夌璇诲彇csv鐨勬柟娉曘鏂囦欢鏍煎紡鏄繖鏍风殑 Region,DATE_,RAW_ACU zh_ch,Jan 27 2017,208172 import csvfrom collections import namedtuple# with open('data.csv') as f:# f_csv = csv.reader(f)# headers = next(f_csv)# for row in...
绛旓細python涓鍙朿sv鏂规硶鏈3绉嶏細绗竴绉嶏紝鏅氭柟娉曡鍙栵紙open鍑芥暟鎵撳紑锛岀劧鍚庝娇鐢╢or寰幆璇诲彇鍐呭锛夛紱绗簩绉嶏紝浣跨敤鐢–SV鏍囧噯搴撹鍙栵紱绗笁绉嶏紝鐢╬andas妯″潡璇诲彇銆
绛旓細CSV鏂囦欢鏈川涓婂氨鏄枃鏈枃浠讹紝鍙笉杩囨瘡琛岀殑鏁版嵁鐢ㄩ楀彿鍒嗛殧銆傛墍浠ヤ綘褰撴垚鏂囨湰鏂囦欢鎵撳紑涓琛屼竴琛岀殑璇鐒跺悗鎷嗗垎灏卞彲浠ヤ簡銆俤ata = []with open(r'd:\temp\demo.csv', 'r') as csv_file: for line in csv_file: data.append(line.strip().split(','))print(data)# 鍙﹀Python鏍囧噯搴撻噷鏈変釜CSV...
绛旓細CSV鏂囦欢鍙堢О涓洪楀彿鍒嗛殧鍊兼枃浠讹紝鏄竴绉嶉氱敤鐨勩佺浉瀵圭畝鍗曠殑鏂囦欢鏍煎紡锛岀敤浠ュ瓨鍌ㄨ〃鏍兼暟鎹紝鍖呮嫭鏁板瓧鎴栬呭瓧绗︺侰SV鏄數瀛愯〃鏍煎拰鏁版嵁搴撲腑鏈甯歌鐨勮緭鍏ャ佽緭鍑烘枃浠舵牸寮忋傞氳繃鐖櫕灏嗘暟鎹姄鍙栫殑涓嬫潵锛岀劧鍚庢妸鏁版嵁淇濆瓨鍦ㄦ枃浠讹紝鎴栬呮暟鎹簱涓紝杩欎釜杩囩▼绉颁负鏁版嵁鐨勬寔涔呭寲瀛樺偍銆傛湰鑺備粙缁Python鍐呯疆妯″潡CSV鐨璇诲啓鎿嶄綔銆1)csv....
绛旓細鐩存帴瀵筩sv鏂囦欢杩涜鏂囦欢璇诲啓鎿嶄綔锛屾瘡涓琛屾槸涓鏉¤褰曪紝鎸夎璇诲彇鍗冲彲锛岀畝鍗曚唬鐮佸涓嬶細with open("XXX.csv","wr") as f:f.readline()f.write()2.浣跨敤绗笁鏂瑰簱涓殑csv鏂囦欢璇诲啓鍑芥暟锛堟湰璐ㄤ笂杩樻槸浣跨敤python鐨勬枃浠惰鍐鏂规硶锛夛紝濡傜瀛﹁绠楀寘pandas鍖呬腑灏辨湁read_csv() to_csv()绛夊嚱鏁帮紝鍏朵粬鐨勪竴浜涚...
绛旓細Python鍙互鐢ㄦ潵姹傝Вcsv琛ㄤ腑鍚勫湴鍖烘渶楂樿柂璧勬槸浠涔堝伐浣溿傞鍏堬紝鎴戜滑闇瑕佸鍏Python涓鐨刢sv妯″潡锛屽嵆import csv锛岀劧鍚庝娇鐢╟sv.reader()鍑芥暟鏉璇诲彇csv鏂囦欢锛屽苟灏嗗叾瀛樺偍鍦ㄤ竴涓狿ython鍒楄〃涓傛帴涓嬫潵锛屾垜浠彲浠ヤ娇鐢╢or寰幆鏉ラ亶鍘嗚鍒楄〃锛屼互渚挎煡鎵炬瘡涓湴鍖虹殑鏈楂樿柂璧勩傛瘮濡傦紝鎴戜滑鍙互浣跨敤if璇彞鏉ユ鏌ユ瘡涓湴鍖虹殑钖祫鏄惁...
