pd.read_parquet()报错

使用 pd.read_parquet() 时产生如下报错:

$ python read_parquet.py
Traceback (most recent call last):
  File "read_parquet.py", line 3, in <module>
    df = pd.read_parquet('t1')
  File "/opt/userhome/atom_guoyanan/anaconda3/lib/python3.7/site-packages/pandas/io/parquet.py", line 281, in read_parquet
    impl = get_engine(engine)
  File "/opt/userhome/atom_guoyanan/anaconda3/lib/python3.7/site-packages/pandas/io/parquet.py", line 32, in get_engine
    raise ImportError("Unable to find a usable engine; "
ImportError: Unable to find a usable engine; tried using: 'pyarrow', 'fastparquet'.
pyarrow or fastparquet is required for parquet support
# read_parquet.py
import pandas as pd

df = pd.read_parquet('jd') 
print(df.columns)
print(df.head(2).T)

安装 pyarrow 和 fastparquet 包即可解决:

$ conda install -c conda-forge pyarrow
$ conda install -c conda-forge fastparquet

重新运行,得到结果:

(base) [atom_xxx@kdd7216 ~]$ python read_parquet.py
Index(['company_id', 'created_at', 'degree_id', 'edited_at',
       'experience_begin', 'experience_end', 'gender', 'level', 'number',
       'origin_company_id', 'position_id', 'real_company_id', 'refreshed_at',
       'salary_begin', 'salary_end', 'status', 'updated_at', 'user_id'],
      dtype='object')
                                       0                      1
company_id                       1228459                1228463
created_at         2013-12-27 16:01:33.0  2014-02-25 13:11:16.0
degree_id                              2                      1
edited_at          2018-07-16 13:36:24.0  2018-07-16 12:31:39.0
experience_begin                       2                      1
experience_end                        10                      0
gender                                 0                      0
level                                  1                      1
number                                10                      1
origin_company_id                1228459                1228463
position_id                          211                    469
real_company_id                        0                      0
refreshed_at       2018-07-16 13:36:24.0  2018-07-16 12:31:39.0
salary_begin                           0                  10000
salary_end                             0                  15000
status                                 4                      4
updated_at         2018-07-16 13:36:34.0  2018-07-16 12:31:39.0
user_id                               95                    270
  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值