In [1]:
import pandas as pd
In [2]:
df = pd.read_csv('data/src/sample_date.csv')
print(df)
In [3]:
print(type(df.index))
In [4]:
print(df['date'].dtype)
In [5]:
df['date'] = pd.to_datetime(df['date'])
print(df['date'].dtype)
In [6]:
df.set_index('date', inplace=True)
print(df)
In [7]:
print(type(df.index))
In [8]:
print(df.index[0])
print(type(df.index[0]))
In [9]:
print(df['2018'])
In [10]:
print(df['2017-11'])
In [11]:
print(df['2017-12-15':'2018-01-15'])
In [12]:
print(df.loc['01/19/2018', 'val_1'])
In [13]:
print(df.loc['20180103', 'val_2'])
In [14]:
df_jp = pd.read_csv('data/src/sample_date_jp.csv')
print(df_jp)
In [15]:
df_jp['date'] = pd.to_datetime(df_jp['date'], format='%Y年%m月%d日')
df_jp.set_index('date', inplace=True)
print(df_jp)
In [16]:
print(type(df_jp.index))
In [17]:
df = pd.read_csv('data/src/sample_date.csv', index_col='date', parse_dates=True)
print(df)
In [18]:
print(type(df.index))
In [19]:
parser = lambda date: pd.to_datetime(date, format='%Y年%m月%d日')
In [20]:
df_jp = pd.read_csv('data/src/sample_date_jp.csv', index_col='date', parse_dates=True, date_parser=parser)
print(df_jp)
In [21]:
print(type(df_jp.index))
In [22]:
s = pd.read_csv('data/src/sample_date.csv', index_col=0, usecols=[0, 1], squeeze=True)
print(s)
In [23]:
print(type(s))
print(type(s.index))
In [24]:
s.index = pd.to_datetime(s.index)
print(s)
In [25]:
print(type(s))
print(type(s.index))
In [26]:
print(s['2017-12-15':'2018-01-15'])