Pandas reading csv as string type

by

Update: this has been fixed: from 0.11.1 you passing str/np.str will be equivalent to using object.

Use the object dtype:

In [11]: pd.read_csv('a', dtype=object, index_col=0)
Out[11]:
                      A                     B
1A  0.35633069074776547     0.745585398803751
1B  0.20037376323337375  0.013921830784260236

or better yet, just don’t specify a dtype:

In [12]: pd.read_csv('a', index_col=0)
Out[12]:
           A         B
1A  0.356331  0.745585
1B  0.200374  0.013922

but bypassing the type sniffer and truly returning only strings requires a hacky use of converters:

In [13]: pd.read_csv('a', converters={i: str for i in range(100)})
Out[13]:
                      A                     B
1A  0.35633069074776547     0.745585398803751
1B  0.20037376323337375  0.013921830784260236

where 100 is some number equal or greater than your total number of columns.

It’s best to avoid the str dtype, see for example here.

More Related Contents:

  1. Import pandas dataframe column as string not int
  2. Change column type in pandas
  3. How do I check if a string is a number (float)?
  4. NumPy or Pandas: Keeping array type as integer while having a NaN value
  5. Convert Pandas column containing NaNs to dtype `int`
  6. Convert columns to string in Pandas
  7. Get list of pandas dataframe columns based on data type
  8. How do I check if a string represents a number (float or int)?
  9. Convert Pandas series containing string to boolean
  10. how many countries have organised more than one edition of olympic games? using python pandas [closed]
  11. What are the ‘levels’, ‘keys’, and names arguments for in Pandas’ concat function?
  12. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  13. Search for String in all Pandas DataFrame columns and filter
  14. Plot a horizontal line on a given plot
  15. selecting across multiple columns with python pandas?
  16. Problem in combining bar plot and line plot (python)
  17. Bar Chart: How to choose color if value is positive vs value is negative
  18. Python pandas: remove everything after a delimiter in a string
  19. import pandas_datareader gives ImportError: cannot import name ‘is_list_like’
  20. vectorize conditional assignment in pandas dataframe
  21. Read csv from Google Cloud storage to pandas dataframe
  22. How to set the pandas dataframe data left/right alignment?
  23. Convert numpy type to python
  24. How to get/set a pandas index column title or name?
  25. Pandas: drop columns with all NaN’s
  26. Getting vertical gridlines to appear in line plot in matplotlib
  27. How can I create the minimum size executable with pyinstaller?
  28. dataframe to long format
  29. plotting value_counts() in seaborn barplot
  30. how to specify the datetime format in read_csv

Leave a Comment