I need those numbers to have the same decimal separator as the input data and I cannot find a way to do this. Output: month ordqty ordprice ordervolume invoiceqty invoiceprice Input: month ordqty ordprice ordervolume invoiceqty invoiceprice I use following code to save the results to an SQLite database: conn = nnect("database.db")ĭf_mce3.to_sql("rawdata", conn, if_exists="replace")ĭf_ka_ext.to_sql("costanalysis_external", conn, if_exists="replace") The SQLite database uses a dot as decimal separator.Įxtract from the code: df_mce3 = pd.read_excel('rawdata/filename.xlsx', header=0, converters=, decimal=',')ĭecimal=',' only works with CSV files. The Excel spreadsheet has comma as decimal separator. ![]() I turn this into a DataFrame, do calculations and save it to an SQLite database. I have an Excel spreadsheet (an extract from SAP).
0 Comments
Leave a Reply. |