blocks|key|376446|text|csv支持制表符分隔的文件。提供delimiter+argument+to+reader|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|376447|import+csv

txt_file+=+r"mytxt.txt"
csv_file+=+r"mycsv.csv"

#+use+'with'+if+the+program+isn't+going+to+immediately+terminate
#+so+you+don't+leave+files+open
#+the+'b'+is+necessary+on+Windows
#+it+prevents+\x1a,+Ctrl-z,+from+ending+the+stream+prematurely
#+and+also+stops+Python+converting+to+/+from+different+line+terminators
#+On+other+platforms,+it+has+no+effect
in_txt+=+csv.reader(open(txt_file,+"rb"),+delimiter+=+'\t')
out_csv+=+csv.writer(open(csv_file,+'wb'))

out_csv.writerows(in_txt)|code-block|syntax|javascript|376448|entityMap|0|LINK|mutability|MUTABLE|url|http://docs.python.org/library/csv.html#csv.reader^0|0|3|G|9|12|6|G|S|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]|$9|X|A|Y|B|C]]|D|@$9|Z|A|10|1|11]]|E|$]]|$1|F|3|G|5|H|7|12|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|13|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

<code>csv</code> supports tab delimited files. Supply the <a href="http://docs.python.org/library/csv.html#csv.reader" rel="noreferrer"><code>delimiter</code> argument to <code>reader</code></a>:

<pre><code>import csv

txt_file = r"mytxt.txt"
csv_file = r"mycsv.csv"

# use 'with' if the program isn't going to immediately terminate
# so you don't leave files open
# the 'b' is necessary on Windows
# it prevents \x1a, Ctrl-z, from ending the stream prematurely
# and also stops Python converting to / from different line terminators
# On other platforms, it has no effect
in_txt = csv.reader(open(txt_file, "rb"), delimiter = '\t')
out_csv = csv.writer(open(csv_file, 'wb'))

out_csv.writerows(in_txt)
</code></pre>

blocks|key|592334|text|为什么在使用csv模块读取文件时应该始终使用'rb‘模式：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|592335|Python+2.7.2+(default,+Jun+12+2011,+15:08:59)+[MSC+v.1500+32+bit+(Intel)]+on+win32
Type+"help",+"copyright",+"credits"+or+"license"+for+more+information.|code-block|syntax|javascript|592336|示例文件中的内容:任何旧垃圾，包括通过从数据库提取blobs或其他内容而获得的控制字符，或者在Excel公式中不当使用CHAR函数，或者...|592337|>>>+open('demo.txt',+'rb').read()
'h1\t"h2a\nh2b"\th3\r\nx1\t"x2a\r\nx2b"\tx3\r\ny1\ty2a\x1ay2b\ty3\r\n'|592338|当Python以文本模式读取文件时，它遵循CP/M、MS-DOS和Windows：\r\n被识别为行分隔符并被用作\n，而\x1a也被识别为文件结束标记。|592339|>>>+open('demo.txt',+'r').read()
'h1\t"h2a\nh2b"\th3\nx1\t"x2a\nx2b"\tx3\ny1\ty2a'+#+WHOOPS|592340|使用'rb‘打开文件的csv按预期工作：|592341|>>>+import+csv
>>>+list(csv.reader(open('demo.txt',+'rb'),+delimiter='\t'))
[['h1',+'h2a\nh2b',+'h3'],+['x1',+'x2a\r\nx2b',+'x3'],+['y1',+'y2a\x1ay2b',+'y3']]|592342|但文本模式不会：|592343|>>>+list(csv.reader(open('demo.txt',+'r'),+delimiter='\t'))
[['h1',+'h2a\nh2b',+'h3'],+['x1',+'x2a\nx2b',+'x3'],+['y1',+'y2a']]
>>>|592344|entityMap^0|6|3|0|0|1N|4|0|0|15|4|1L|2|1P|4|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|15|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|16|8|@$9|17|A|18|B|C]]|D|@]|E|$]]|$1|M|3|N|5|H|7|19|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|1A|8|@$9|1B|A|1C|B|C]|$9|1D|A|1E|B|C]|$9|1F|A|1G|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|H|7|1H|8|@]|D|@]|E|$I|J]]|$1|S|3|T|5|6|7|1I|8|@]|D|@]|E|$]]|$1|U|3|V|5|H|7|1J|8|@]|D|@]|E|$I|J]]|$1|W|3|X|5|6|7|1K|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|H|7|1L|8|@]|D|@]|E|$I|J]]|$1|10|3|-4|5|6|7|1M|8|@]|D|@]|E|$]]]|11|$]]

Why you should always use 'rb' mode when reading files with the <code>csv</code> module:

<pre><code>Python 2.7.2 (default, Jun 12 2011, 15:08:59) [MSC v.1500 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
</code></pre>

What's in the sample file: any old rubbish, including control characters obtained by extracting blobs or whatever from a database, or injudicious use of the <code>CHAR</code> function in Excel formulas, or ...

<pre><code>&gt;&gt;&gt; open('demo.txt', 'rb').read()
'h1\t"h2a\nh2b"\th3\r\nx1\t"x2a\r\nx2b"\tx3\r\ny1\ty2a\x1ay2b\ty3\r\n'
</code></pre>

Python follows CP/M, MS-DOS, and Windows when it reads files in text mode: <code>\r\n</code> is recognised as the line separator and is served up as <code>\n</code>, and <code>\x1a</code> aka Ctrl-Z is recognised as an END-OF-FILE marker.

<pre><code>&gt;&gt;&gt; open('demo.txt', 'r').read()
'h1\t"h2a\nh2b"\th3\nx1\t"x2a\nx2b"\tx3\ny1\ty2a' # WHOOPS
</code></pre>

csv with a file opened with 'rb' works as expected:

<pre><code>&gt;&gt;&gt; import csv
&gt;&gt;&gt; list(csv.reader(open('demo.txt', 'rb'), delimiter='\t'))
[['h1', 'h2a\nh2b', 'h3'], ['x1', 'x2a\r\nx2b', 'x3'], ['y1', 'y2a\x1ay2b', 'y3']]
</code></pre>

but text mode doesn't:

<pre><code>&gt;&gt;&gt; list(csv.reader(open('demo.txt', 'r'), delimiter='\t'))
[['h1', 'h2a\nh2b', 'h3'], ['x1', 'x2a\nx2b', 'x3'], ['y1', 'y2a']]
&gt;&gt;&gt;
</code></pre>

blocks|key|376520|text|我就是这么做的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|376521|import+csv

with+open(txtfile,+'r')+as+infile,+open(csvfile,+'w')+as+outfile:
+++++stripped+=+(line.strip()+for+line+in+infile)
+++++lines+=+(line.split(",")+for+line+in+stripped+if+line)
+++++writer+=+csv.writer(outfile)
+++++writer.writerows(lines)|code-block|syntax|javascript|376522|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

This is how i Do it

<pre><code>import csv

with open(txtfile, 'r') as infile, open(csvfile, 'w') as outfile:
 stripped = (line.strip() for line in infile)
 lines = (line.split(",") for line in stripped if line)
 writer = csv.writer(outfile)
 writer.writerows(lines)
</code></pre>

So I want to convert a simple tab delimited text file into a csv file. If I convert the txt file into a string using string.split('\n') I get a list with each list item as a string with '\t' between each column. I was thinking I could just replace the '\t' with a comma but it won't treat the string within the list like string and allow me to use string.replace. Here is start of my code that still needs a way to parse the tab "\t". 

<pre><code>import csv
import sys

txt_file = r"mytxt.txt"
csv_file = r"mycsv.csv"

in_txt = open(txt_file, "r")
out_csv = csv.writer(open(csv_file, 'wb'))

file_string = in_txt.read()

file_list = file_string.split('\n')

for row in ec_file_list: 
 out_csv.writerow(row)
</code></pre>

Convert tab-delimited txt file into a csv file using Python

数据库

Windows

Python

所以我想把一个简单的制表符分隔的文本文件转换成csv文件。如果我使用string.split('\n')将txt文件转换为一个字符串，我会得到一个列表，其中每个列表项都是一个字符串，每列之间有一个'\t‘。我在想，我可以用逗号替换'\t‘，但它不会将列表中的字符串视为字符串，并允许我使用string.replace。这...

问使用Python将制表符分隔的txt文件转换为csv文件
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Python将制表符分隔的txt文件转换为csv文件EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问使用Python将制表符分隔的txt文件转换为csv文件
EN