本文介绍了是否可以使用read_csv仅读取特定行?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个csv文件,如下所示:
I have a csv file that looks like this:
TEST 2012-05-01 00:00:00.203 ON 1 2012-05-01 00:00:11.203 OFF 0 2012-05-01 00:00:22.203 ON 1 2012-05-01 00:00:33.203 OFF 0 2012-05-01 00:00:44.203 OFF 0 TEST 2012-05-02 00:00:00.203 OFF 0 2012-05-02 00:00:11.203 OFF 0 2012-05-02 00:00:22.203 OFF 0 2012-05-02 00:00:33.203 OFF 0 2012-05-02 00:00:44.203 ON 1 2012-05-02 00:00:55.203 OFF 0并且不能摆脱"TEST"字符串.
是否可以检查行是否以日期开头,并且仅读取行中的日期?
Is it possible to check whether a line starts with a date and read only those that do?
推荐答案from cStringIO import StringIO import pandas s = StringIO() with open('file.csv') as f: for line in f: if not line.startswith('TEST'): s.write(line) s.seek(0) # "rewind" to the beginning of the StringIO object pandas.read_csv(s) # with further parameters…
更多推荐
是否可以使用read
发布评论