Talk-Data-2-Me / SLMR

https://www.kaggle.com/c/springleaf-marketing-response
0 stars 0 forks source link

help needed: datetime variable #6

Open xiaoxiding opened 9 years ago

xiaoxiding commented 9 years ago

As we agree to use this springleaf competition as kinda of test to build our competition frame work, let's start with data cleaning functions, so help needed:)

There are 16 datetime variables in the dataset. If anyone could write functions to get year, month, week, day of week and/or anything else you can think of from them, that would be great. Below is the name list of those variables. They are 'object' in springleaf dataset.

date_col = ['VAR_0073','VAR_0075', 'VAR_0156', 'VAR_0157', 'VAR_0158', 'VAR_0159', 'VAR_0166', 'VAR_0167', 'VAR_0168', 'VAR_0169', 'VAR_0176', 'VAR_0177', 'VAR_0178', 'VAR_0179', 'VAR_0204', 'VAR_0217']