I am having data in excel and reading as below and i am trying to convert all data to string-
import pandas as pd
df=pd.read_excel('excel')
df.fillna('(Null)').astype(str)
even though i convert to string using astype(str), but in some case, i get float values as below(67.0) and how do i avoid this keeping just as string '67'-
Name id
0 A 123
1 B 67.0
2 C 30
3 D 40
4 E 50
df=pd.read_excel('excel', dtype=str)?67.0should be float value in input file, so after converting to string get67.0to'67.0'