魔法のメモ

CG N GAME BLOG

Python_16.ライブラリ/Datetime , Pandas

import datetime
today = datetime.date.today()
 
datetime.datetime.now()
datetime.datetime(2021, 6, 29, 0, 56, 53, 636589)
 
today.month
6
 
today-datetime.timedelta(days=1)
datetime.date(2021, 6, 27)
 
today.strftime('%Y年%m月%d日')
#stringfortime?
2021年06月28日
 
today.strftime('%Y/%m/%d')
2021/06/28
 
--
!pip3 install pandas
#pip3をインストールしていない場合?
 
import pandas as pd
df=pd.DataFrame([
              [1,2,3],
              [4,5,6],
              [7,8,9]
              ])
df

f:id:heroroom:20210629100445p:plain

 
df=pd.read_csv('/content/sample_data/california_housing_test.csv')
 
df.head()
#頭から五行目まで取得

f:id:heroroom:20210629100508p:plain

df.head(3)

f:id:heroroom:20210629100525p:plain

df.tail()
 f:id:heroroom:20210629100607p:plain
df.tail(3)

f:id:heroroom:20210629100624p:plain



df.iloc[:,:3]
#:=全て、:3=三列目の一つ前まで取得する(0列目、1列目、2列目)
 

f:id:heroroom:20210629101009p:plain

 
df.iloc[:,:3].head()
#頭五行?

f:id:heroroom:20210629101037p:plain

 

df['housing_median_age']>30

f:id:heroroom:20210629100826p:plain

 

df[df['housing_median_age']>30]

f:id:heroroom:20210629101359p:plain

df.shape
(3000, 9)
 
df.mean()
#平均値

f:id:heroroom:20210629101428p:plain

df.std()

f:id:heroroom:20210629101447p:plain

df.max()
#最大値

f:id:heroroom:20210629101502p:plain

 
df.describe()
#統計量をまとめてみたい

f:id:heroroom:20210629101513p:plain