pythonpython-3.xpandasdataframepython-datetime
convert object (numeric value) to datetime using pandas
I have the data with time column as shown below, how to convert this as date and time using pandas
Solution
Consider df:
In [208]: df
Out[208]:
Time
0 2384798300
1 1500353475
2 7006557825
3 1239779541
4 1237529231
Use datetime.fromtimestamp with df.apply:
In [200]: from datetime import datetime
In [209]: df['Time'] = df['Time'].apply(lambda x: datetime.fromtimestamp(x))
In [210]: df
Out[210]:
Time
0 2045-07-28 01:28:20
1 2017-07-18 10:21:15
2 2192-01-11 15:33:45
3 2009-04-15 12:42:21
4 2009-03-20 11:37:11
- Making a polygon with Python matplotlib
- python-polars split string column into many columns by delimiter
- Why (x / y)[i] faster than x[i] / y[i]?
- How to connect a microsoft SQL Server database to Open Data Discovery (odd-odd-platform)?
- python libraries for ssh handling
- polynomial section of the AKS algorithm in Python
- How to get current index of element in polars list
- Polars equivalent to Pandas min_count on groupby
- How do I select the top k rows of a python polars dataframe for each group?
- Python Polars Window Function With Literal Type
- Polars: Fill missing months per group
- How do I markup a flash message in Flask?
- Cannot modify port, windows port setting problem
- How to provide only one of multiple optional parameters in FastAPI?
- Using http methods with django rest framework
- How to count work days between date columns with Polars
- How can I upload multiple videos with youtube api python
- Formatter black is not working on my VSCode...but why?
- Using print statements only to debug
- Python command line input doesn't delete japanese characters when pressing the erase key
- How can I validate CSS within a script?
- Why is max() function so much slower when comparing 2 elements vs direct comparison with an if statement?
- How to return the highest value from a multi dimensional array?
- Why can't I raise to a negative power in numpy?
- Replace letters inside words that start with and end with a specific letter not occurring anywhere else with the same amount of a specific character
- How to automate word document from Json data using python
- How can I remove 'www.' from original URL through [urllib] parse in python?
- Correct usage of async session on pytest
- Fit a power law to empirical data in Python
- Type hint that a function never returns