是否可以使用read

本文介绍了是否可以使用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…