CSV文件以Python读取 [英] CSV file Read in Python
问题描述
我有两种类型的csv，其数据如下:
I have two type of csv's having data like:
从具有两个列的电子表格创建的csv中读取格式1.
Format 1 read from csv created from spreadsheet having two coloums.
datas = [[u'Woeoe;"ww@w.com"'], [u'wqqq;"Ww2@2.com"'], [u'Asasasa;"122@22.co.in"']]
从文本编辑器创建的csv中读取的
format 2保存为.csv并具有类似的数据
format 2 read from the csv created from text editor save as .csv and having data like
fname lname,email@email.com
fname1 lname2 ,email@email1.com
datas = [[u'Vaada sasoe ', u'ssdoe@d.com'], [u'skdod asksd ', u'shashias@ssdsd.com']]
我已经使用csv阅读器读取了这些文件:
i have read those files with csv reader:
reader = csv.reader(input, quotechar='"', delimiter=',')
datas = []
for line in reader:
datas.append(line)
我该如何处理这两种不同格式的csv阅读器输出?如果我输入任何类型的csv，我可以在读入一种简单的逗号分隔格式(如上述format2)的同时转换数据的方式吗?基本上，我要读取的数据应始终为format2.
how do i handle those two different format output of csv reader ? is their any way that i can convert the data while reading in to one simple comma separated format like format2 mention above if i input the any type of csv ? basically i want to data read should be in always in format2.
推荐答案
第一个文件使用;"作为分隔符.因此，您只需要对读者说出来即可.
The first file use ";" as delimiter. So, you just have to say it to the reader.
尝试使用csv.reader(input, quotechar='"', delimiter=';')
这篇关于CSV文件以Python读取的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
