Convert integer to string type when retrieving values from a pandas dataframe

Question

I am trying to convert output of data (from Integer to String) from a List generated using Pandas.

I got the output of data from a csv file.

Here is my code that covers expression using Pandas (excluding part where it shows how to come up with generation of object 'InFile' (csv file)).

import pandas as pd
....

with open(InFile) as fp:
     skip = next(it.ifilter(
        lambda x: x[1].startswith('ID'),
        enumerate(fp)
     ))[0]

dg = pd.read_csv(InFile, usercols=['ID'], skiprows=skip)
dgl = dg['ID'].values.tolist()

Currently, output is a List (example below).

 [111111, 2222, 3333333, 444444]

I am trying to match data from other List (which is populated into String or Varchar(data type in MySQL), but somehow, I cannot come up with any match. My previous post -> How to find match from two Lists (from MySQL and csv)

So, I am guessing that the data type from the List generated by Pandas is an Integer.

So, how do I convert the data type from Integer to String?

Which line should I add something like str(10), for an example?

You want to convert ID to string?

cs95
– cs95

2017-08-24 15:27:00 +00:00
Commented Aug 24, 2017 at 15:27 — cs95
– cs95, Commented Aug 24, 2017 at 15:27
ID is just the name of column.

Java
– Java

2017-08-24 16:03:09 +00:00
Commented Aug 24, 2017 at 16:03 — Java
– Java, Commented Aug 24, 2017 at 16:03
Yes, I understood that.

cs95
– cs95

2017-08-24 16:03:30 +00:00
Commented Aug 24, 2017 at 16:03 — cs95
– cs95, Commented Aug 24, 2017 at 16:03

cs95 · Accepted Answer · 2017-08-24 15:27:48Z

2

You can use pd.Series.astype:

dgl = dg['ID'].astype(str).values.tolist()
print(dgl)

Output:

['111111', '2222', '3333333', '444444']

answered Aug 24, 2017 at 15:27

cs95

406k106 gold badges744 silver badges797 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert integer to string type when retrieving values from a pandas dataframe

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related