1.时间格式转换
import pandas as pd
order = pd. read_table( 'D:/pandas/meal_order_info.csv' , sep= ',' , encoding= 'gbk' )
order[ 'use_start_time' ] = pd. to_datetime( order[ 'use_start_time' ] )
order[ 'lock_time' ] = pd. to_datetime( order[ 'lock_time' ] )
print ( '转换后类型为:' , order[ [ 'use_start_time' , 'lock_time' ] ] . dtypes)
转换后类型为: use_start_time datetime64[ns]
lock_time datetime64[ns]
dtype: object
2.提取 年, 月, 日, 周, 星期, 星期名
use_start_time 与 lock_time 中分析其一
year = [ i. year for i in order[ 'lock_time' ] ]
month = [ i. month for i in order[ 'lock_time' ] ]
day = [ i. day for i in order[ 'lock_time' ] ]
week = [ i. week for i in order[ 'lock_time' ] ]
weekday = [ i. weekday( ) for i in order[ 'lock_time' ] ]
weekname = [ i. day_name for i in order[ 'lock_time' ] ]
print ( '年:' , year[ : 5 ] )
print ( '月:' , month[ : 5 ] )
print ( '日:' , day[ : 5 ] )
print ( '周:' , week[ : 5 ] )
print ( '星期:' , weekday[ : 5 ] )
print ( '星期名:' , weekname[ : 5 ] )
年: [2016, 2016, 2016, 2016, 2016]
月: [8, 8, 8, 8, 8]
日: [1, 1, 1, 1, 1]
周: [31, 31, 31, 31, 31]
星期: [0, 0, 0, 0, 0]
星期名: [<bound method Timestamp.day_name of Timestamp('2016-08-01 11:11:46')>, <bound method Timestamp.day_name of Timestamp('2016-08-01 11:31:55')>, <bound method Timestamp.day_name of Timestamp('2016-08-01 12:54:37')>, <bound method Timestamp.day_name of Timestamp('2016-08-01 13:08:20')>, <bound method Timestamp.day_name of Timestamp('2016-08-01 13:07:16')>]
3.时间统计、
Timestamp.min() Timestamp.max() Timestamp.mean()
timemin = order[ 'lock_time' ] . min ( )
timemax = order[ 'lock_time' ] . max ( )
print ( '订单最早的时间:' , timemin)
print ( '订单最晚的时间:' , timemax)
print ( '订单持续时间:' , timemax - timemin)
订单最早的时间: 2016-08-01 11:11:46
订单最晚的时间: 2016-08-31 21:56:12
订单持续时间: 30 days 10:44:26
checkTime = order[ 'lock_time' ] - order[ 'use_start_time' ]
print ( '平均点餐时间:' , checkTime. mean( ) )
print ( '最短点餐时间:' , checkTime. min ( ) )
print ( '最长点餐时间:' , checkTime. max ( ) )
平均点餐时间: 0 days 01:12:10.326923
最短点餐时间: -1 days +00:05:03
最长点餐时间: 16 days 00:08:00
注:最长时间 和 最短时间 按照实际是可以列为 “异常值”的