検索
検索

Using pd.to_datetime to convert int with format HHMMSS

debugcn 投稿 Dev
1
BrunoAlb

I am using the following code in Python to transform a dataframe column of ints corresponding to hour, minute and seconds(E.g. 230100) to a time format.

data_name['Time'] = data_name['Time'].apply(lambda y: pd.to_datetime(str(y),format='%H%M%S'))

I am having the following error:

ValueError: time data '230100' does not match format '%H%M%S' (match)

The previous type of code worked perfectly to convert an int with the info YYYYMMDD.

Any ideas?

jezrael

For me working nice in pandas 0.25.0, what is your pandas version? Also apply is not necessary here:

data_name = pd.DataFrame({'Time':[230100,230100]})

data_name['Time'] = (pd.to_datetime(data_name['Time'].astype(str), 
                                    errors='coerce',
                                    format='%H%M%S').dt.time)
print (data_name)
       Time
0  23:01:00
1  23:01:00

この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。

侵害の場合は、連絡してください[email protected]

編集
0

コメントを追加

0
サインイン

関連記事

分類Dev

pd.to_datetimeを使用してintをHHMMSS形式で変換する

分類Dev

SQL DateTime Format Convert

分類Dev

Convert columns to posixct using sapply and keeping datetime format in R

分類Dev

Converting dataframe object to date using to_datetime

分類Dev

`to_datetime` limit or misuse? ValueError : Doesn't match format specified

分類Dev

Int convert to str using for cycle

分類Dev

PHP: Convert epoch to MySQL DateTime format

分類Dev

How to convert a datetime format to minutes - pandas

分類Dev

How to convert string data with variable format to datetime?

分類Dev

How to convert a column with null values to datetime format?

分類Dev

Convert a specific format dateTime string to DateTime in C#

分類Dev

How to convert to datetime if the format of dates changes gradually through the column?

分類Dev

yyyymmdd.hhmmss date time-formatに名前はありますか？

分類Dev

遅いpd.to_datetime（）

分類Dev

How to convert int timestamp to DateTime in json_serializable flutter

分類Dev

convert plain string to xml format using Linux command

分類Dev

Convert unstructured data(text) into structured format using java

分類Dev

Using melt() to convert wide to long data format that requires value lookup

分類Dev

Convert binary data to valid image format, using Imagemagick (or other tool)

分類Dev

How to convert specific CSV format to JSON using Python

分類Dev

Can I convert a date in the format YYYYMMDDHHMM using date?

分類Dev

Cannot convert ssh.com key to ppk format using Puttygen

分類Dev

Unable to convert (int*) to int

分類Dev

How to clean columns & convert to datetime using python

分類Dev

Rails DateTime re-format using #{DateTime.now}

分類Dev

pd.to_datetimeは、df.rolling計算のためにdatetimeをintに変換しません

分類Dev

Pandas to_datetime with multiindex

分類Dev

Using boost parse datetime string: With single digit hour format

分類Dev

format（）int as float

Related 関連記事

  1. 1

    pd.to_datetimeを使用してintをHHMMSS形式で変換する

  2. 2

    SQL DateTime Format Convert

  3. 3

    Convert columns to posixct using sapply and keeping datetime format in R

  4. 4

    Converting dataframe object to date using to_datetime

  5. 5

    `to_datetime` limit or misuse? ValueError : Doesn't match format specified

  6. 6

    Int convert to str using for cycle

  7. 7

    PHP: Convert epoch to MySQL DateTime format

  8. 8

    How to convert a datetime format to minutes - pandas

  9. 9

    How to convert string data with variable format to datetime?

  10. 10

    How to convert a column with null values to datetime format?

  11. 11

    Convert a specific format dateTime string to DateTime in C#

  12. 12

    How to convert to datetime if the format of dates changes gradually through the column?

  13. 13

    yyyymmdd.hhmmss date time-formatに名前はありますか？

  14. 14

    遅いpd.to_datetime（）

  15. 15

    How to convert int timestamp to DateTime in json_serializable flutter

  16. 16

    convert plain string to xml format using Linux command

  17. 17

    Convert unstructured data(text) into structured format using java

  18. 18

    Using melt() to convert wide to long data format that requires value lookup

  19. 19

    Convert binary data to valid image format, using Imagemagick (or other tool)

  20. 20

    How to convert specific CSV format to JSON using Python

  21. 21

    Can I convert a date in the format YYYYMMDDHHMM using date?

  22. 22

    Cannot convert ssh.com key to ppk format using Puttygen

  23. 23

    Unable to convert (int*) to int

  24. 24

    How to clean columns & convert to datetime using python

  25. 25

    Rails DateTime re-format using #{DateTime.now}

  26. 26

    pd.to_datetimeは、df.rolling計算のためにdatetimeをintに変換しません

  27. 27

    Pandas to_datetime with multiindex

  28. 28

    Using boost parse datetime string: With single digit hour format

  29. 29

    format（）int as float

ホットタグ

アーカイブ