时间戳

首页 > 解决方案 > 如何在谷歌协作中使用 python 从 csv 文件中读取特定列

python - 如何在谷歌协作中使用 python 从 csv 文件中读取特定列

问题描述

df = pd.read_csv(io.BytesIO(uploaded['data.csv']))



ParserError                               Traceback (most recent call last)
<ipython-input-22-a523fd2e8c08> in <module>()
      1 import io
      2 
----> 3 df = pd.read_csv(io.BytesIO(uploaded['data.csv']))
      4 
      5 

3 frames
/usr/local/lib/python3.7/dist-packages/pandas/io/parsers.py in read(self, nrows)
   2155     def read(self, nrows=None):
   2156         try:
-> 2157             data = self._reader.read(nrows)
   2158         except StopIteration:
   2159             if self._first_chunk:

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader.read()

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._read_low_memory()

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._read_rows()

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._tokenize_rows()

pandas/_libs/parsers.pyx in pandas._libs.parsers.raise_parser_error()

ParserError: Error tokenizing data. C error: Expected 3 fields in line 77, saw 5

标签： pythonpandasdataframecsvdata-analysis

解决方案

import pandas as pd #import pandas
fread =  pd.read_csv('filepath/filename.csv') #make fread as object
freaddf = pd.DataFrame(fread, columns=['col1name', 'col2name', 'col3name'])
print(freaddf.to_string())

推荐阅读