python 导入csv-Python 导入csv报错的解决办法

日常做分析导数据源进python，有时候会出现报错及显示乱码的问题，今天来梳理一下常见的报错。

python 代码

import pandas as pd

import numpy as np

df=pd.read_csv("invest_record_2018.csv’)

报错信息

UnicodeDecodeError Traceback (most recent call last)

pandas/_libs/parsers.pyx in pandas._libs.parsers.TextReader._convert_tokens

(pandas/_libs/parsers.c:14858)()

pandas/_libs/parsers.pyx in

pandas._libs.parsers.TextReader._convert_with_dtype

(pandas/_libs/parsers.c:17119)()

报错信息显示文件编码错误，所以来调整下代码

import pandas as pd

import numpy as np

df=pd.read_csv("invest_record_2018.csv",encoding="utf-8")

报错依旧，换下编码

import pandas as pd

import numpy as np

df=pd.read_csv("invest_record_2018.csv",encoding="gbk")

使用encoding="ISO-8859-1" 也可以不再报错

import pandas as pd

import numpy as np

df&#