Convert DataFrame timestamp column to Data Type and split Date and Hour

General Usage
, , ,
1

Hello everybody, I need to Convert DataFrame timestamp column to Data Type and split Date and Hour, I have this column:

Screen Shot 2020-10-12 at 8.50.53 PM
Screen Shot 2020-10-12 at 8.50.53 PM554×690 30.2 KB

I try to use the function unix2datetime(x) but I don’t know how we can do with a column in a DataFrame, I try the next line of code:

eventsDataFrame[!,[:timecreated]] = convert.(unix2datetime(eventsDataFrame[!,[:timecreated]]))

Then, I need to convert to Date formant and split into two news columns wit the Date and the Hour.

Thanks for your help

2

Don’t index the data frame with a vector, use df[!, :timecreated] instead of df[!, [:timecreated]].