Python date, character interchange
Date Spin string
1. Read data from Excel, in Excel date this column data format type is "Short Date"
Test = Pd.read_excel (' f:/test.xlsx ')
Test.head (2)
2. View data types for read data
test[' Date '].apply (lambda x:type (x))
The data type is a timestamp, and the Year,month,day property gets the month-and-day information that the timestamp refers to.
Output timestamp corresponding to the month and day information
test[' Date '].apply (lambda x:print (x.year, X.month, X.day)), the output results are as follows:
4. Convert timestamps to strings, view data types
myString = test[' Date '].apply (lambda x:x.strftime ('%y-%m-%d '))
Mystring.apply (Lambda x:type (x))
The output is as follows and has all been converted to STR types
String Turn Date
1. The sample data used is long like this
Mystring.apply (Lambda x:print (x, type (x))
2. String to date denaturing operation
Mystring.apply (Lambda x:type (time.strptime (x, '%y-%m-%d '))
This transsexual doctor is the Strptime built-in function of time, the important thing to say three times
String to date, using Time.striptime (), the return value type is a time tuple struct_time
String to date, using Time.striptime (), the return value type is a time tuple struct_time
String to date, using Time.striptime (), the return value type is a time tuple struct_time
If you retrieve the "string date" on the Internet, you will generally be told this. Uses Time.striptime (), but does not continue to analyze what type of result is returned, how to extract the date, month, day, and so on.
It is called a transsexual operation because after this step, the actual change of string to date has been implemented. But the form that may be rendered, as shown in the following figure, is not what you ultimately want, and then we have to deform the operation.
3. Date tuple of the deformation record
Convert a time tuple to a timestamp
Mystring.apply (Lambda x:time.mktime (time.strptime (x, '%y-%m-%d '))
The return value is float, still not the form we want, and continues to deform.
Mystring.apply (Lambda X:datetime.datetime.fromtimestamp (Time.mktime (Time.strptime (x, '%y-%m-%d ')))
Using Datetime.datetime.fromtimestamp () to deform, the parameter is a timestamp type.
See the result is done, is the form we want. This time, and can be cheerful use of year,month,day properties.
Mystring.apply (Lambda X:datetime.datetime.fromtimestamp (Time.mktime (Time.strptime (x, '%y-%m-%d ')). Year)
String Direct extraction year/month/day
If our purpose is simply to extract the information of the year and the month, the string is completely difficult to get out of the smart analyst. What kind of guests, what kind of stay. See recruit and dismantle recruit, extrapolate is the core competition of person. Split it up with a split and get it done.
Mystring.apply (Lambda x:x.split ('-'))
See the Calendar.
The functions of the Calendar module are calendar-related, such as printing a month's character calendar.
Import Calendar
Cal = Calendar.month (2017, 9)
Print (CAL)
In an instant this month will be the end of the day, will be a holiday. Learn to multiply early, grow daily essential ~
Remember the long press the image below, identify the two-dimensional code in the map, pay attention to "data analyst Notes", with the March Mulberry progress ^_^