Use Python to Change csv Data Column Format
This is a time formatting problem/philosophy by Excel.  For some reason, Microsoft prefers to hide seconds and sub-seconds on user displays:   even MSDOS's dir command omitted seconds.
If I were you, I'd use Excel's format operation and set it to display seconds, then save the spreadsheet as CSV and see if it put anything in it to record the improved formatting.
If that doesn't work, you might explore creating a macro which does the formatting, or use one of the IPC to Excel to command it to do your bidding.
I am using python pandas to read csv file. The csv file has a datetime column that has second precisions "9/1/2015  9:25:00 AM", but if I open in excel, it has only minute precisions "9/1/15 9:25". Moreover, when I use the pd.read_csv() function, it only shows up to minute precision. Is there any way that I could solve the problem using python? Thanks much in advance.