0

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
J_Coder
  • 707
  • 5
  • 14
  • 32

0 Answers0