Java自学者论坛

 找回密码
 立即注册

手机号码,快捷登录

恭喜Java自学者论坛(https://www.javazxz.com)已经为数万Java学习者服务超过8年了!积累会员资料超过10000G+
成为本站VIP会员,下载本站10000G+会员资源,会员资料板块,购买链接:点击进入购买VIP会员

JAVA高级面试进阶训练营视频教程

Java架构师系统进阶VIP课程

分布式高可用全栈开发微服务教程Go语言视频零基础入门到精通Java架构师3期(课件+源码)
Java开发全终端实战租房项目视频教程SpringBoot2.X入门到高级使用教程大数据培训第六期全套视频教程深度学习(CNN RNN GAN)算法原理Java亿级流量电商系统视频教程
互联网架构师视频教程年薪50万Spark2.0从入门到精通年薪50万!人工智能学习路线教程年薪50万大数据入门到精通学习路线年薪50万机器学习入门到精通教程
仿小米商城类app和小程序视频教程深度学习数据分析基础到实战最新黑马javaEE2.1就业课程从 0到JVM实战高手教程MySQL入门到精通教程
查看: 796|回复: 0

pandas用read_csv时编码问题解决

[复制链接]
  • TA的每日心情
    奋斗
    7 天前
  • 签到天数: 745 天

    [LV.9]以坛为家II

    2041

    主题

    2099

    帖子

    70万

    积分

    管理员

    Rank: 9Rank: 9Rank: 9

    积分
    704660
    发表于 2021-7-8 18:33:24 | 显示全部楼层 |阅读模式

    在pandas用read_csv时,遇到编码错误的, 可带

    encoding : str, default None

    Encoding to use for UTF when reading/writing (ex. ‘utf-8’)

    官网的标准编码类型解释,其中GBK GB2312 GB18030 UTF-8是经常遇到的问题,

    https://docs.python.org/3/library/codecs.html#standard-encodings

     

    Codec Aliases Languages
    ascii 646, us-ascii English
    big5 big5-tw, csbig5 Traditional Chinese
    big5hkscs big5-hkscs, hkscs Traditional Chinese
    cp037 IBM037, IBM039 English
    cp273 273, IBM273, csIBM273

    German

    New in version 3.4.

    cp424 EBCDIC-CP-HE, IBM424 Hebrew
    cp437 437, IBM437 English
    cp500 EBCDIC-CP-BE, EBCDIC-CP-CH, IBM500 Western Europe
    cp720   Arabic
    cp737   Greek
    cp775 IBM775 Baltic languages
    cp850 850, IBM850 Western Europe
    cp852 852, IBM852 Central and Eastern Europe
    cp855 855, IBM855 Bulgarian, Byelorussian, Macedonian, Russian, Serbian
    cp856   Hebrew
    cp857 857, IBM857 Turkish
    cp858 858, IBM858 Western Europe
    cp860 860, IBM860 Portuguese
    cp861 861, CP-IS, IBM861 Icelandic
    cp862 862, IBM862 Hebrew
    cp863 863, IBM863 Canadian
    cp864 IBM864 Arabic
    cp865 865, IBM865 Danish, Norwegian
    cp866 866, IBM866 Russian
    cp869 869, CP-GR, IBM869 Greek
    cp874   Thai
    cp875   Greek
    cp932 932, ms932, mskanji, ms-kanji Japanese
    cp949 949, ms949, uhc Korean
    cp950 950, ms950 Traditional Chinese
    cp1006   Urdu
    cp1026 ibm1026 Turkish
    cp1125 1125, ibm1125, cp866u, ruscii

    Ukrainian

    New in version 3.4.

    cp1140 ibm1140 Western Europe
    cp1250 windows-1250 Central and Eastern Europe
    cp1251 windows-1251 Bulgarian, Byelorussian, Macedonian, Russian, Serbian
    cp1252 windows-1252 Western Europe
    cp1253 windows-1253 Greek
    cp1254 windows-1254 Turkish
    cp1255 windows-1255 Hebrew
    cp1256 windows-1256 Arabic
    cp1257 windows-1257 Baltic languages
    cp1258 windows-1258 Vietnamese
    cp65001  

    Windows only: Windows UTF-8 (CP_UTF8)

    New in version 3.3.

    euc_jp eucjp, ujis, u-jis Japanese
    euc_jis_2004 jisx0213, eucjis2004 Japanese
    euc_jisx0213 eucjisx0213 Japanese
    euc_kr euckr, korean, ksc5601, ks_c-5601, ks_c-5601-1987, ksx1001, ks_x-1001 Korean
    gb2312 chinese, csiso58gb231280, euc- cn, euccn, eucgb2312-cn, gb2312-1980, gb2312-80, iso- ir-58 Simplified Chinese
    gbk 936, cp936, ms936 Unified Chinese
    gb18030 gb18030-2000 Unified Chinese
    hz hzgb, hz-gb, hz-gb-2312 Simplified Chinese
    iso2022_jp csiso2022jp, iso2022jp, iso-2022-jp Japanese
    iso2022_jp_1 iso2022jp-1, iso-2022-jp-1 Japanese
    iso2022_jp_2 iso2022jp-2, iso-2022-jp-2 Japanese, Korean, Simplified Chinese, Western Europe, Greek
    iso2022_jp_2004 iso2022jp-2004, iso-2022-jp-2004 Japanese
    iso2022_jp_3 iso2022jp-3, iso-2022-jp-3 Japanese
    iso2022_jp_ext iso2022jp-ext, iso-2022-jp-ext Japanese
    iso2022_kr csiso2022kr, iso2022kr, iso-2022-kr Korean
    latin_1 iso-8859-1, iso8859-1, 8859, cp819, latin, latin1, L1 West Europe
    iso8859_2 iso-8859-2, latin2, L2 Central and Eastern Europe
    iso8859_3 iso-8859-3, latin3, L3 Esperanto, Maltese
    iso8859_4 iso-8859-4, latin4, L4 Baltic languages
    iso8859_5 iso-8859-5, cyrillic Bulgarian, Byelorussian, Macedonian, Russian, Serbian
    iso8859_6 iso-8859-6, arabic Arabic
    iso8859_7 iso-8859-7, greek, greek8 Greek
    iso8859_8 iso-8859-8, hebrew Hebrew
    iso8859_9 iso-8859-9, latin5, L5 Turkish
    iso8859_10 iso-8859-10, latin6, L6 Nordic languages
    iso8859_11 iso-8859-11, thai Thai languages
    iso8859_13 iso-8859-13, latin7, L7 Baltic languages
    iso8859_14 iso-8859-14, latin8, L8 Celtic languages
    iso8859_15 iso-8859-15, latin9, L9 Western Europe
    iso8859_16 iso-8859-16, latin10, L10 South-Eastern Europe
    johab cp1361, ms1361 Korean
    koi8_r   Russian
    koi8_t  

    Tajik

    New in version 3.5.

    koi8_u   Ukrainian
    kz1048 kz_1048, strk1048_2002, rk1048

    Kazakh

    New in version 3.5.

    mac_cyrillic maccyrillic Bulgarian, Byelorussian, Macedonian, Russian, Serbian
    mac_greek macgreek Greek
    mac_iceland maciceland Icelandic
    mac_latin2 maclatin2, maccentraleurope Central and Eastern Europe
    mac_roman macroman, macintosh Western Europe
    mac_turkish macturkish Turkish
    ptcp154 csptcp154, pt154, cp154, cyrillic-asian Kazakh
    shift_jis csshiftjis, shiftjis, sjis, s_jis Japanese
    shift_jis_2004 shiftjis2004, sjis_2004, sjis2004 Japanese
    shift_jisx0213 shiftjisx0213, sjisx0213, s_jisx0213 Japanese
    utf_32 U32, utf32 all languages
    utf_32_be UTF-32BE all languages
    utf_32_le UTF-32LE all languages
    utf_16 U16, utf16 all languages
    utf_16_be UTF-16BE all languages
    utf_16_le UTF-16LE all languages
    utf_7 U7, unicode-1-1-utf-7 all languages
    utf_8 U8, UTF, utf8 all languages
    utf_8_sig   all languages
    哎...今天够累的,签到来了1...
    回复

    使用道具 举报

    您需要登录后才可以回帖 登录 | 立即注册

    本版积分规则

    QQ|手机版|小黑屋|Java自学者论坛 ( 声明:本站文章及资料整理自互联网,用于Java自学者交流学习使用,对资料版权不负任何法律责任,若有侵权请及时联系客服屏蔽删除 )

    GMT+8, 2024-3-29 05:05 , Processed in 0.066718 second(s), 29 queries .

    Powered by Discuz! X3.4

    Copyright © 2001-2021, Tencent Cloud.

    快速回复 返回顶部 返回列表