pandas difference of time columns

Solutions on MaxInterview for pandas difference of time columns by the best coders in the world

Search
showing results for - "pandas difference of time columns"
Deandre
09 Jun 2019
1df = pd.DataFrame(columns=["one", "two"])
2
3df.one = ["2019-01-24","2019-01-27"]
4df.two = ["2019-01-28", "2020-01-29"]
5
6df.one = pd.to_datetime(df.one)
7df.two = pd.to_datetime(df.two)
8
9print(df)
10# OUTPUT
11#          one        two
12# 0 2019-01-24 2019-01-28
13# 1 2019-01-27 2020-01-29
14
15difference = (df.two - df.one)
16
17print(difference)
18# OUTPUT
19# 0     4 days
20# 1   367 days
21# dtype: timedelta64[ns]
source
similar questions
pandas compare two columnscomparing two dataframe columnsdifference between 2 timestamps pandashow to find mean of one column based on another column in pythonfind difference between two pandas dataframesdifference between 2 dataframescomparing timestamp in pandasselect 2 cols from dataframe python pandasdatediff in seconds in pandaspython pandas check if two columns are equalfilter dataframe by two columnspandas series vs dataframeminimum of two columns in pandaspandas difference between object and categorypandas difference between rows in a columncompare multiple columns in pandascorrelation between two columns pandaspython pandas difference between two data framesget columns based on dtype pandaspandas difference between datesif df 5bcol 5d unique 28 29 3d 3d2pandas difference between two dataframesdataframe how to substruct 2 dates
queries leading to this page
get the difference between two date time columns in pandaspandas calculate time difference between column and specific datepandas dataframe columns differencepython pandas calculate difference between columnspandas difference of time columnspandas create column with time differencetime difference in python in new column pandasfind diff between dates in two columns pandaspandas difference of time columns