保存到CSV文件python时datetime格式更改 [英] datetime format change when save to csv file python

问题描述

我有一个像这样的数据框:

I have a dataframe like this:

In [67]:
call_df.head()
Out[67]:
timestamp   types
1   2014-06-30 07:00:55 Call_O
2   2014-06-30 07:00:05 Call_O
3   2014-06-30 06:54:55 Call_O
501 2014-06-30 11:24:01 Call_O

当我将该数据帧保存到csv文件中时，datetime的格式发生了更改，并且丢失了秒.我只是将这段代码保存到csv文件中:

When I saved that dataframe to csv file, the format of datetime is change as well as I lose the seconds. I just put this code to save into csv file:

call_df.to_csv('D:/Call.csv')

csv文件输出如下:

The csv file output is like this:

在这里我想问一下，如何将相同的日期时间格式从数据帧保存到csv文件中

In here I want to ask, how to save the same datetime format from dataframe into csv file

推荐答案

to_csv accepts a date_format param, so please try this:

call_df.to_csv('D:/Call.csv', date_format='%Y-%m-%d %H:%M:%S')

在您的样本数据集上得出:

On your sample data set this yielded:

timestamp,types
2014-06-30 07:00:55,Call_O
2014-06-30 07:00:05,Call_O
2014-06-30 06:54:55,Call_O
2014-06-30 11:24:01,Call_O

这篇关于保存到CSV文件python时datetime格式更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！