開發與維運

pandas在Series中的時間日期(datetime64)類型怎麼取出年月日並進行判斷。

在Series中通過dt就可以獲得其日期屬性

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

df = pd.read_csv('ahdy-2019-03-04-data.csv', sep=',', parse_dates=['發佈時間'])
print(df.shape)
print(df.columns)
print(df.dtypes)
df = df.loc[df['發佈時間'].dt.year == 2019]
print(df['發佈時間'])

這是其他幾個可能用到的,比如變成字符串就是.str,比如我們想通過字符串的長度篩選數據就可以通過str.len() == xx

pd = pd[pd['sid'].str.len() == 18]

str = CachedAccessor("str", StringMethods)
dt = CachedAccessor("dt", CombinedDatetimelikeProperties)
cat = CachedAccessor("cat", CategoricalAccessor)
plot = CachedAccessor("plot", gfx.SeriesPlotMethods)
sparse = CachedAccessor("sparse", SparseAccessor)

Leave a Reply

Your email address will not be published. Required fields are marked *