代码报错收集
蜗牛跳码
这个作者很懒,什么都没留下…
展开
-
UnicodeDecodeError: ‘utf-8‘ codec can‘t decode byte 0xd3 in position 0: invalid continuation byte
这种问题是因为导出的csv文件包含中文,且这些中文的编码不是utf-8等,直接用excel打开这些文件还会出现乱码。用记事本打开这些csv则正常显示,然后用记事本另存为UTF-8之后,用excel打开也能够正常显示,并且用pandas读取时指明encoding='utf-8'也能正常读取了。如果读取批量的csv时,或者csv的行数达到数百万时,就不能通过记事本另存为来更改encoding了,那应该怎么做来保证pandas能正常读取这些csv呢?中文的csv文件的编码改成utf-8的方法。原创 2023-05-17 00:30:02 · 2030 阅读 · 2 评论 -
1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column
MARK1055 - Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'student.b.C_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by, Time: 0.00200原创 2022-01-01 09:40:16 · 858 阅读 · 0 评论 -
1630 - FUNCTION a.Count does not exist. Check the ‘Function Name Parsing and Resolution‘ section in
1630 - FUNCTION a.Count does not exist原创 2021-12-31 22:49:08 · 1251 阅读 · 0 评论