Handling Date and Time Variables | Day 34 | 100 Days of Machine Learning

Managing date and time variables is crucial for effective data analysis. Techniques include parsing and extracting components, creating new features, and handling missing values through imputation or interpolation. These practices ensure accurate and meaningful utilization of date and time information in your dataset.

============================
Do you want to learn from me?
============================

📱 Grow with us:

[arshad]

Thanks for the sharing Valuable knowledge free of cost....

[LYRICS.RR_]

Hello Sir,
I appreciate your efforts, I'm watching your playlist in 2024 that seems very good content and you cover all aspects of ML prerequisites.
Thanks for your extraordinary efforts!
God bless You!

[Praveer]

simply superb, such a nice explanation

[parthshukla]

thanks sir it is helping a lot everyday i am watching 1 video from this playlist

[petersharma]

what an explaination thankyou so much sir!!!!❤

[sneharj]

Wow! Amazing video for handling date, time variables. With an example, explained very nicely. I m very greatful to this channel & always be for bringing informative n interesting videos always in free. Quality content n professional teacher like Nitish sir 🙏🙏. Thanku so much to u sir. Ur channel is really very great 👍🥰.

[AVINASHSURADKAR-je]

12:43
try this to
# converting to datetime datatype

time['date'] = pd.to_datetime(time['date'], errors='coerce')

time.head()

to get the hour, minute, and second

[jitendratrivedi]

Very useful, lot of information in one video.

[parthshah]

i dont know if you guys encountered any errors while executing the above code but i did and here are the solutions
while extracting date convert the column into datetime and than extract it
# extracting the year
date['date'] = pd.to_datetime(date['date'])
date['date_year'] = date['date'].dt.year
date.head()

you can repeat this if you're encountering it ahead int the video

[MonkeyDLuffy]

Only video (and notebook) for working with data time data❤

[Fallen]

Hey! Can you make a video series on detailed time series data? Like Resampling, Shifting and Rolling etc., ? Also using Financial Data

[minnikeswarrao]

Can we signify the date based on holidays? Not just sundays but also other public holidays

[jamalshah]

can you provide us the OneNote Notes for 100 days of ML?

[stevegabrial]

Plz plz dont make your video channel private or put videos on some education site. each video are grasp in a single day. I'm waiting for a day when u make GNN video with some super coding on air. thanks

[vikashkumar-cree]

Hi Nitish, in lecture 31, power transformer, you dealt with the numerical dataset, if there were categorical columns as well, then how would power functions have worked?

[furryfun]

can you please tell how to change the time format say if it given in 24 hours format and we want to work on 12 hours format

[subhajitdey]

how to handle if we only have 2018-01, 2018-02, 2018-03....these type of data where we have year and week ?

[milipandey]

people have no patience, crowd will go with gain knowledge in short time.. if you mention 100 days its like people want one night success.

[raja.]

you should use
date['week_number'] =

instead of date['date_week'] = date['date'].dt.week