Forum Discussion
Python: DateTimeIndex not showing in PowerBI
Hi, my code runs smoothly in Spyder, so I don't think it's an issue with my code. However, most of my variables are dataframes, and when I copy the whole code over to the Python Script in Power B...
Anonymous,
I can reproduce your issue, just add a statement in the button of your code like pattern below:
# 'dataset' holds the input data for this script import datetime import pandas as pd import numpy as np def datetimeix(df): df['Date\t'] = pd.DatetimeIndex(df['Date\t']) df.set_index('Date\t', inplace = True) return df df = pd.read_csv(r'C:\Users\JimmyTao\Desktop\Test.csv') dataset = dfAfter expand, the result is like this:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, part of the code is shown below:
import datetime
import pandas as pd
import numpy as np
import statsmodels.api as sm
def datetimeix(df):
df['Date'] = pd.DatetimeIndex(df['Date'])
df.set_index('Date', inplace = True)
return(df)
df = pd.read_csv(r'C:\Users\blai\Documents\5 year dataset.csv', encoding = "ISO-8859-1")
mthnsr = cumtotal(df)
mthnsr = datetimeix(mthnsr)
Anonymous,
I can reproduce your issue, just add a statement in the button of your code like pattern below:
# 'dataset' holds the input data for this script
import datetime
import pandas as pd
import numpy as np
def datetimeix(df):
df['Date\t'] = pd.DatetimeIndex(df['Date\t'])
df.set_index('Date\t', inplace = True)
return df
df = pd.read_csv(r'C:\Users\JimmyTao\Desktop\Test.csv')
dataset = df
After expand, the result is like this:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.