Python pandas: how to specify data types when reading an Excel file?

by

You just specify converters. I created an excel spreadsheet of the following structure:

names   ages
bob     05
tom     4
suzy    3

Where the “ages” column is formatted as strings. To load: 

import pandas as pd

df = pd.read_excel('Book1.xlsx',sheetname="Sheet1",header=0,converters={'names':str,'ages':str})
>>> df
       names ages
   0   bob   05
   1   tom   4
   2   suzy  3

More Related Contents:

  1. Why does the following code cant get value of n_fold = 1?
  2. How to change the order of DataFrame columns?
  3. Filter dataframe rows if value in column is in a set list of values [duplicate]
  4. Add missing dates to pandas dataframe
  5. Converting a Pandas GroupBy output from Series to DataFrame
  6. Pandas: sum DataFrame rows for given columns
  7. datetime dtypes in pandas read_csv
  8. Pandas DataFrame: replace all values in a column, based on condition
  9. Pandas – Slice large dataframe into chunks
  10. Calculate average of every x rows in a table and create new table
  11. selecting from multi-index pandas
  12. Group duplicate column IDs in pandas dataframe
  13. How to convert column with list of values into rows in Pandas DataFrame
  14. How to remove square bracket from pandas dataframe
  15. Remove or replace spaces in column names
  16. pandas dataframe columns scaling with sklearn
  17. Python Pandas update a dataframe value from another dataframe
  18. Mapping columns from one dataframe to another to create a new column [duplicate]
  19. Action with pandas SettingWithCopyWarning
  20. python dataframe pandas drop column using int
  21. How to plot two columns of a pandas data frame using points
  22. which is faster for load: pickle or hdf5 in python
  23. How to read a list of parquet files from S3 as a pandas dataframe using pyarrow?
  24. Return multiple columns from pandas apply()
  25. Python Pandas – Merge based on substring in string
  26. Filling in date gaps in MultiIndex Pandas Dataframe
  27. append dictionary to data frame
  28. What values are valid in Pandas ‘Freq’ tags?
  29. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  30. start index at 1 for Pandas DataFrame

Leave a Comment