python-calamine
python-calamine copied to clipboard
Line breaks not consistent
Hi! We've noticed that calamine handles line breaks different than all other engines when reading excel files via pandas, running the following code:
import pandas as pd
df = pd.read_excel('data.xlsx')
print(df)
df_calamine = pd.read_excel('data.xlsx', engine='calamine')
print(df_calamine)
we get:
print(df): header1 header2 header\nwith break 0 1 4 7 1 2 5 8 2 3 6 9
print(df_calamine): header1 header2 header\r\nwith break 0 1 4 7 1 2 5 8 2 3 6 9
As you can see, calamine is representing line breaks as r\n\ while other engines consider usual \n break.
It's bug (?) in upstream.