Read excel file to python but time format has changed

Viewed 47

when I read the excel file to python.

import pandas as pd
data = pd.read_excel('1.xlsx')
data 

Some part of my time data uploaded successfully but the another part of time data has some problems. Problem is on these columns (in_time, call_time, process_in_time, out_time).

  1. Why is this happened?
  2. And how to handle and normalize this time data ?

click here to see image

0 Answers
Related