python - 从一天的时间中删除小时、分钟和秒，Python
问题描述
taxa_bruta_cdi = pd.read_csv("dados CDI .csv",delimiter=";",encoding='cp1252')
taxa_cdi= pd.DataFrame(taxa_bruta_cdi,columns=["Data","Media"])
taxa_cdi['Data'] = pd.to_datetime(taxa_cdi['Data']).dt.normalize()
taxa_cdi=taxa_cdi.pivot_table(index="Data",values="Media",aggfunc='sum')
taxa_cdi.sort_index(axis=0, level=None, ascending=True, inplace=False, kind='quicksort', na_position='last', sort_remaining=True, by=None)
我想从日期中删除小时、分钟和秒。
解决方案
试试这个：
taxa_cdi['Data'] = taxa_cdi['Data'].dt.strftime('%Y-%m-%d')