Python script changes data in date column.

Question

Hello!After running a python script in power query, one of my columns containing date data is completely changed to some text. The column is not even part of the python script. All the dates are replaced with "Microsoft.OleDb.Date".&nbsp;The source data is an Excel file located on SharePoint. Any idea as to what could cause it or how to revert the data back?Best regards,Denis&nbsp;

lbendlin · Answer

The column is not even part of the python script
Then how else does it participate in the output?&nbsp; Your python script is supposed to create a dataframe that is handed back to Power Query as a table.

dnsleu · Answer

Hey,I have 17 columns. The script that I run only adds a new column at the end. The results in this column are based on the values in 3 of columns.&nbsp;When I run the script, I get all the original dataframe back, with all 17 columns + 1 (the 1 computed by python). In these original 17 columns, only 1 of them (presented above) gets its values changed. The other 16 columns maintain their values.&nbsp;Perhaps I did not do a good job clarifying in the first place.&nbsp;

lbendlin · Answer

Maybe you can show a sanitized version of the Power Query script.

dnsleu · Answer

Sure!# 'dataset' holds the input data for this script&nbsp;import pandas as pd&nbsp;&nbsp;&nbsp;&nbsp;def&nbsp;calculate_Ordering(row):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;curr_row&nbsp;= row['Chapter']&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;row_grp&nbsp;= row['Name']&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;row_main&nbsp;= row['Main']&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;prj&nbsp;= row['Project']&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;main_groups&nbsp;= dataset[(dataset['Main'] == True) &amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (dataset['Name'] !=&nbsp;row_grp) &amp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (dataset['Project'] ==&nbsp;prj)]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rel_chpt&nbsp;=&nbsp;main_groups[main_groups['Chapter'] &lt;&nbsp;curr_row]['Chapter'].max()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if&nbsp;row_main:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return&nbsp;curr_row&nbsp;&nbsp;&nbsp;&nbsp; else:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if str(curr_row).startswith(str(rel_chpt)):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return&nbsp;rel_chpt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return&nbsp;curr_row&nbsp;&nbsp;&nbsp;dataset['Order'] =&nbsp;dataset.apply(calculate_Ordering, axis=1)&nbsp;print(dataset)The column affected is "Deadline", which only has date type data. It is not included in the script and is the only one affected. A possible work around would be to have it as text before running the Python script and then convert it back to date type, but this still does not explain why the data gets lost / modified in the first place.

lbendlin · Answer

There is no point in the last print(dataset)&nbsp; command.&nbsp;
&nbsp;
your dataset will completely replace any prior output, including that date column.
&nbsp;
I'd need to see more of the Power Query script before and after the Python part&nbsp; to be able to assist more.

Forum Discussion

Python script changes data in date column.

6 Replies

Related content

Change Python script data source to Postgresql in Power BI

Fabric Python Notebook Execution Logs

Power BI Python Visualisations being depreciated?

How creating a Python custom library

Python Rest API Python 404 ExecuteQueries