莫愁前路无知己，天下谁人不识君。。。。

Python2.7----txt转csv(含读取txt、csv)

上一篇 / 下一篇  2017-09-08 14:52:43 / 个人分类：python知识精髓

查看( 1605 ) / 评论( 0 ) / 评分( 0 / 0 )
借助网友和自己的总结，关于python中的读取文件各种格式，代码如下：
# coding:utf-8
import csv
login.txt中数据：
吕亮(2376) <2376@qq.com>; 苏龙(2361) <2361@qq.com>; 
蒋慧(2364) <2364@qq.com>; 何仁(2365) <2365@qq.com>; 
张文(2334) <2334@qq.com>; 黄东(2319) <2319@qq.com>; 
A.
.txt------->.csv
txt_file = 'E:\login.txt'
csv_file = "E:\login.csv"
in_txt = csv.reader(open(txt_file, "r"), delimiter=';', escapechar='\n')
#in_txt = csv.reader(open(txt_file, "r"), delimiter=',')
out_csv = csv.writer(open(csv_file, 'wb')) # 不加b的话有空格
out_csv.writerows(in_txt)
#############将txt格式读到CSV格式的表格中############
B.
export.csv数据
id   line
8250 4634
8251 4640
8270 4007
data = []
with open("E:\export.csv") as f:
    temp = csv.reader(f)
    headers = next(temp) #此行去除列名
    for row in temp:
        data.append(row)
print data
---->[['8250', '4634'], ['8251', '4640'], ['8270', '4007']]
with open('E:\export.csv') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        print(row['id'], row['line']),
---->('8250', '4634') ('8251', '4640') ('8270', '4007')
export001.txt中数据：
8250,4634
8251,4640
8270,4007
lines = [line.strip().split() for line in open('E:\export001.txt')]
print lines
---->[['8250,4634'], ['8251,4640'], ['8270,4007']]
8250,4634
8251,4640
8270,4007
---->[['8250', '4634'], ['8251', '4640'], ['8270', '4007']]
export1.csv数据
8250 4634
8251 4640
8270 4007
import numpy as np
data = np.loadtxt("E:\export1.csv", delimiter=',')
print data
---->[[ 8250.  4634.]
     [ 8251.  4640.]
     [ 8270.  4007.]]


收藏 举报

TAG: CSV Python python txt

 

评分：0

我来说两句

Open Toolbar