datatable不支持中文路径的解决方法
from datatable import dt, f
import pandas as pd
# 中英文路径
csv_cn = r'D:\Test\中文路径\Export2023.CSV'
csv_en = r'D:\Test\Export2023.CSV'
该csv共有1300多万条记录,11列。
pandas读取csv,用时 9.92s
df_pd = pd.read_csv(csv_en)
executed in 9.92s
datatable读取csv,用时 1.22s
df_dt = dt.fread(csv_en, skip_blank_lines=True)
executed in 1.22s
datatable读取csv(中文路径)时出错
df_cn = dt.fread(csv_cn, skip_blank_lines=True)
IOError Traceback (most recent call last)
Cell In[41], line 1
----> 1 df_cn = dt.fread(csv_cn, skip_blank_lines=True)
IOError: Unable to obtain size of D:Test中文路径Export2023.CSV: [errno