How to Make a Date Column in Python?

Asked Oct 11 '22 at 14:23

Active Oct 11 '22 at 14:23

Viewed 12 times

I have a data frame with the below format:

I need to split into tow columns: 1) date (year and month) and 2) values

I have written the below code but returns dimension error:

date_range = pd.date_range(start = '1952-01-1' , end = '2015-01-01' , freq = 'M')
dateFrame = pd.DataFrame({'date':date_range,'val': values.values.tolist()})

asked Oct 11 '22 at 14:23

AmirHossein Ahrari

`df.melt('year', var_name='month')` – mozway Oct 11 '22 at 14:24
post an example of what the output should look like, please – Golden Lion Oct 11 '22 at 15:15
melt function works. – AmirHossein Ahrari Oct 12 '22 at 06:58

How to Make a Date Column in Python?

0 Answers0