You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I've been trying to read excel file using polars.read_excel, but came across a calamine error: Xlsx error, which states that Expecting alphanumeric character, got 24.
Is there any solution? Many thanks!
data = pl.read_excel(r'D:/MT_PAYDTL-NEW-20568-20241012041604.xlsx', engine='calamine', schema_overrides={"其他税前收入备注": pl.Utf8, "其他税前扣款备注": pl.Utf8, "其他税后扣款备注": pl.Utf8, "其他税后收入备注": pl.Utf8, "特殊奖金备注": pl.Utf8 },infer_schema_length=None)
data = data.to_pandas()
data = data.where(pd.notnull(data), np.nan)
The text was updated successfully, but these errors were encountered:
I've been trying to read excel file using polars.read_excel, but came across a calamine error: Xlsx error, which states that Expecting alphanumeric character, got 24.
Is there any solution? Many thanks!
The text was updated successfully, but these errors were encountered: