日期转换
通常文件读取的日期都为字符型,为了计算,我们需要将这转化为日期型数据。主要用到to_datetime(x, format)函数,x是你要处理的日期型字符串,format是你要输出的日期型格式。下面我们以输出年月日格式为例:
# -*- coding: utf-8 -*-
import pandas as pd
df = pd.read_csv(r"/Users/herenyi/Downloads/4/4.16/data.csv", encoding='utf8')
df_dt = pd.to_datetime(df.注册时间, format='%Y/%m/%d');
结果如下:
df_dt
Out[122]:
0 2011-01-01
1 2011-01-01
2 2011-01-01
3 2011-01-01
4 2011-01-01
5 2011-01-01
6 2011-01-01
7 2011-01-01
8 2011-01-01
9 2011-01-01
10 2011-01-01
11 2011-01-01
12 2011-01-01
13 2011-01-01
14 2011-01-01
15 2011-01-01
16 2011-01-01
17 2011-01-01
18 2011-01-01
19 2011-01-01
20 2011-01-01
21 2011-01-01
22 2011-01-01
23 2011-01-01
24 2011-01-01
25 2011-01-01
26