pandas column to string code example

Example 1: pandas change column to a string

total_rows['ColumnID'] = total_rows['ColumnID'].astype(str)

Example 2: pandas change dtype to string

df['id'].astype(str)
0    1
1    5
2    z
3    1
4    1
5    7
6    2
7    6

Example 3: in dataframe particular column to string

df["fruit"] = df["fruit"].astype("|S")

Example 4: pandas dataframe froms string

import sys
if sys.version_info[0] < 3: 
    from StringIO import StringIO
else:
    from io import StringIO

import pandas as pd

TESTDATA = StringIO("""col1;col2;col3
    1;4.4;99
    2;4.5;200
    3;4.7;65
    4;3.2;140
    """)

df = pd.read_csv(TESTDATA, sep=";")

Example 5: pandas frame convert string

df['DataFrame Column'] = pd.to_numeric(df['DataFrame Column'])