pandas read xlsx adding .0 to text and fillna not working
newbie here, Pandas is adding .0 to the end of my text and fillna is not working Here is my code df_GetInfo = pandas.read_excel(report, sheet_name=”Report1″, engine=”openpyxl”) # Set column types df_DeliveriesInfo = df_DeliveriesInfo.astype({‘Delivery Nr’: str, ‘Receiver Nr’: str, ‘Transport Nr’: str, ‘Forwarder Code’: str}) # Replace na values by empty strings df_DeliveriesInfo.fillna(”, inplace=True)` The issue … Read more