Leave dates as strings using read_excel function from pandas in python

by

I ran into an identical problem, except pandas was oddly converting only some cells into datetimes. I ended up manually converting each cell into a string like so:

def undate(x):
    if pd.isnull(x):
        return x
    try:
        return x.strftime('%d/%m/%Y')
    except AttributeError:
        return x
    except Exception:
        raise

for i in list_of_possible_date_columns:
    df[i] = df[i].apply(undate)

More Related Contents:

  1. Convert Excel style date with pandas
  2. How to write to an existing excel file without overwriting data (using pandas)?
  3. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  4. datetime dtypes in pandas read_csv
  5. pandas dataframe groupby datetime month
  6. How to convert columns into one datetime column in pandas?
  7. pandas out of bounds nanosecond timestamp after offset rollforward plus adding a month offset
  8. Find the end of the month of a Pandas DataFrame Series
  9. Create a day-of-week column in a Pandas dataframe using Python
  10. Converting between datetime and Pandas Timestamp objects
  11. append dataframe to excel with pandas
  12. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  13. Convert date from excel in number format to date format python [duplicate]
  14. Pandas: Datetime Improperly selecting day as month from date [duplicate]
  15. How to obtain sheet names from XLS files without loading the whole file?
  16. Merge rows based on value (pandas to excel – xlsxwriter)
  17. Write to StringIO object using Pandas Excelwriter?
  18. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  19. Putting many python pandas dataframes to one excel worksheet
  20. pandas bar plot combined with line plot shows the time axis beginning at 1970
  21. Specifying date format when converting with pandas.to_datetime
  22. how to test if a variable is pd.NaT?
  23. Pandas: Reading Excel with merged cells
  24. Truncate `TimeStamp` column to hour precision in pandas `DataFrame`
  25. Datetime conversion – How to extract the inferred format?
  26. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  27. Python: Datetime to season
  28. How do I convert timestamp to datetime.date in pandas dataframe?
  29. Pandas datetimes with different formats in the same column
  30. Get weekday/day-of-week for Datetime column of DataFrame

Leave a Comment