How to read data as a text only in pandas python

Asked Dec 20 '21 at 12:35

Active Dec 20 '21 at 12:50

Viewed 209 times

I have many csv files in S3 and i want to read only 7 columns from each files through pandas. But in the output csv files for numerical column I am getting decimal values as well.like for count 9.0,6.0 but i want to read everything as a text only. like 9 and 6. I tried from pd.read_fwf but still issue is not resolved. can someone help me out please.

cols=["name","Phone","cost","count","location","location1", "family_count"]

reader = pd.read_csv(io.BytesIO(body), delimiter=',', quotechar='"',
                         encoding='utf8', quoting=csv.QUOTE_ALL, skipinitialspace=True, 
                          usecols=cols)
reader.reset_index()

csv_buffer = BytesIO()

reader.to_csv(csv_buffer, index=False)

I tried to specify dtype=object

reader = pd.read_csv(io.BytesIO(body), delimiter=',', quotechar='"',
                     encoding='utf8', quoting=csv.QUOTE_ALL, skipinitialspace=True, 
                      usecols=cols,dtype=object)

but then i an getting type error:"Data type not understood"

edited Dec 20 '21 at 12:50

asked Dec 20 '21 at 12:35

Ravikant Pandey

Have you tried the dtype argument in pd.read_csv? It will help you to force the data types of incoming data. – Mahendra Singh Dec 20 '21 at 12:38
Does this answer your question? [Pandas read\_csv dtype read all columns but few as string](https://stackoverflow.com/questions/49684951/pandas-read-csv-dtype-read-all-columns-but-few-as-string) – Paul Dec 20 '21 at 12:42
NO I want to read everything as a text – Ravikant Pandey Dec 20 '21 at 12:51
Hi @Mahendra I tried but getting Type error – Ravikant Pandey Dec 20 '21 at 12:52
@RavikantPandey then its difficult to comment without looking at the data. It would be great if you can provide a sample of your input data – Mahendra Singh Dec 20 '21 at 13:00

How to read data as a text only in pandas python

0 Answers0