首页 \ 问答 \ 在Python中解析年,月,日,小时,分钟,秒(Parsing year, month, day, hour, minute, second in Python)

在Python中解析年,月,日,小时,分钟,秒(Parsing year, month, day, hour, minute, second in Python)

我有一个带标题的csv文件,它们是:年,月,日,小时,分钟,秒,firstName

我在Python中有以下代码:

import pandas as pd
from datetime import datetime
parse = lambda x: datetime.strptime(x, '%Y-%m-%d %H:%M:%S')
df = pd.read_csv('filename.csv',  
           parse_dates={'Date/Time': ['year', 'month', 'day', 'hour', 'minute', 'second']}, 
            index_col=0)
df[:5]

显示表格时,日期/时间列显示为

约会时间
2013 6 26 18 57 22

代替

约会时间
2013-6-26 18:57:22

任何帮助,将不胜感激。 谢谢。


I have a csv file with headers and they are: year, month, day, hour, minute, second, firstName

I have the following code in Python:

import pandas as pd
from datetime import datetime
parse = lambda x: datetime.strptime(x, '%Y-%m-%d %H:%M:%S')
df = pd.read_csv('filename.csv',  
           parse_dates={'Date/Time': ['year', 'month', 'day', 'hour', 'minute', 'second']}, 
            index_col=0)
df[:5]

When the table is shown the Date/Time column shows as

Date/Time
2013 6 26 18 57 22

instead of

Date/Time
2013-6-26 18:57:22

Any help would be appreciated. Thank you.


原文:https://stackoverflow.com/questions/27112591
更新时间:2019-12-07 11:42

最满意答案

更改您的parser并像这样使用它:

import pandas as pd
from datetime import datetime

def parse(year, month, day, hour, minute, second):
    return year+ '-' +month+ '-' +day+ ' ' +hour+ ':' +minute+ ':' +second

df = pd.read_csv('test.csv', parse_dates={'Date/Time':['year', 'month', 'day', 'hour', 'minute', 'second']}, 
           date_parser=parse,
           index_col=0)

Change your parser and use it like this:

import pandas as pd
from datetime import datetime

def parse(year, month, day, hour, minute, second):
    return year+ '-' +month+ '-' +day+ ' ' +hour+ ':' +minute+ ':' +second

df = pd.read_csv('test.csv', parse_dates={'Date/Time':['year', 'month', 'day', 'hour', 'minute', 'second']}, 
           date_parser=parse,
           index_col=0)
2014-11-24

相关文章

更多

最新问答

更多
  • 删除不适用于JSP中使用for循环的每个id(Deletion not working for every id using for loop in JSP)
  • 如何从std :: filesystem :: path中删除引号(How to remove quotation marks from std::filesystem::path)
  • 验证多个控制器方法的URL路径(Validate URL path for several controller methods)
  • 如何在datarow []中的列中找到最大值?(How to find max value in a column in a datarow[] ?)
  • 如何使用预定义文本替换来自数据库的部分结果(How do I replace part of result coming from Database with predefined text)
  • Selenium Java注入了新的Javascript函数(Selenium Java inject new Javascript function)
  • 使用.on的多个下拉菜单选择文本仅适用于第一个下拉列表(Multiple Dropdowns Menu Selection text using .on works only on first dropdown)
  • 快速将黄土曲线添加到大型数据集图中的方法(Quick way to add loess curve to large data set graph)
  • FilteringSelect in mvc(FilteringSelect in mvc)
  • 在Delphi XE2中开发Mac或iOS应用程序需要哪些硬件/软件?(What hardware/software is necessary to develop Mac or iOS apps in Delphi XE2?)
  • 在原型的构造函数中初始化属性时获取“未定义”(Getting 'undefined' when a property is initialized in the constructor of a prototype)
  • 通过越狱加载的应用程序的Documents文件夹位置(Location of Documents folder for an app loaded via jailbreak)
  • 在OpenGL中使用可编程和固定管道功能(Using both programmable and fixed pipeline functionality in OpenGL)
  • 将任何用户输入重定向到单独的底层程序(redirect any user input to a separate underlying program)
  • 编辑文本不能正常工作android(Edit texts not working properly android)
  • “user_denied”Facebook应用页面上的Facebook用户区域设置(Facebook user locale on “user_denied” facebook app page)
  • 在大图像中找到小的部分透明图像的坐标(find coordinates of small partially-transparent image within a large image)
  • 我如何在cakephp 3.1中获得完整的相对路径?(How i can get full relative path of image in cakephp 3.1?)
  • 如何保存拖动标记的新本地化?(How to save new localization of dragged marker?)
  • MySQL UPDATE vs INSERT和DELETE(MySQL UPDATE vs INSERT and DELETE)
  • 在执行查询之前,在SQLAlchemy模型中将datetime转换为unix时间戳?(Convert datetime to unix timestamp in SQLAlchemy model before executing query?)
  • OpenCL与OpenGL互操作的优势(Advantage of OpenCL interoperability with OpenGL)
  • 如何解析用点和等分隔的数据然后添加到listview(How to parsing data from delimited with dot and equal then add to listview)
  • 带调试输出的X3解析器段错误(BOOST_SPIRIT_X3_DEBUG)(X3 parser segfaults with debug output (BOOST_SPIRIT_X3_DEBUG))
  • 将文件夹名称添加到fgrep结果(Add folder name to fgrep result)
  • 在MySQL中加载一个表是非常慢的(Loading one table in MySQL is ridiculously slow)
  • 如何将JSON放入PHP变量?(How do I put JSON into a PHP Variable?)
  • 如何绕过Microsoft.Speech.Recognition中的不流畅?(How to bypass disfluencies in Microsoft.Speech.Recognition?)
  • 原点的最后一行是什么?(What is the last row of an origin for?)
  • 将字符串转换为javascript中的操作(Translate String to operation in javascript)