Load dataframe columns from CSV as strings only

Question

I need to convert all columns of a csv file into str while reading with Pandas in python. What is the most efficient way to write this code?

df = pd.read_csv("datafile.csv", sep = "\s+", names = ["lvl12",
"etime", "press", "gph", "temp", "rh", "dpdp", "wdir", "wspd"])
df['lvl12'].astype(str)
df['etime'].astype(str)
df['press'].astype(str)
df['gph'].astype(str)
df['temp'].astype(str)
df['rh'].astype(str)
df['dpdp'].astype(str)
df['wdir'].astype(str)
df['wspd'].astype(str)

df=df.astype(str)

BENY
– BENY

2018-03-23 04:22:57 +00:00
Commented Mar 23, 2018 at 4:22 — BENY
– BENY, Commented Mar 23, 2018 at 4:22

cs95 · Accepted Answer · 2018-03-23 04:24:15Z

3

You can do one better; add the dtype=str argument when reading df in:

df = pd.read_csv(
    "datafile.csv", 
    sep="\s+", 
    names=["lvl12", "etime", "press", ...],
    dtype=str
)

answered Mar 23, 2018 at 4:24

cs95

406k106 gold badges744 silver badges797 bronze badges

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

2 Comments

BENY Over a year ago

Yep , I am thinking of this way :-)

seaotternerd Over a year ago

That's awesome! There are so many useful key-word arguments lurking in pandas.

seaotternerd · Accepted Answer · 2018-03-23 04:23:46Z

0

You can call astype on the whole dataframe at once:

df.astype(str)

answered Mar 23, 2018 at 4:23

seaotternerd

6,4292 gold badges49 silver badges59 bronze badges

Collectives™ on Stack Overflow

Load dataframe columns from CSV as strings only

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related