pandas dataframe ignoring zeros left side of column value

Asked Dec 03 '18 at 16:29

Active Dec 03 '18 at 16:29

Viewed 58 times

I am reading an excel file using pandas library.The one of the column of excel contains numbers like 2961,0895,0073.But when I am reading them the '0' is getting removed in output.Like below

Model ID
a    2961.0
b    895.0
c    73.0

How I can retain entire four digit value before decimal ?

import pandas
import xlrd
df = pandas.read_excel(r"C:\Drive\Details.xlsx")
FORMAT = ['Model','ID']
df_selected = df[FORMAT]
print(df_selected)

asked Dec 03 '18 at 16:29

Chinmay Nayak

1

if it contains leading zeros in excel then it's not a number but a string. If that's effectively the case then https://stackoverflow.com/a/32591786/9754169 – Yuca Dec 03 '18 at 16:31
Do you want to store the data as a string? – busybear Dec 03 '18 at 16:31
@busybearyes I want them to store as string. – Chinmay Nayak Dec 03 '18 at 16:33
Issue fixed after adding converter = {"column name": str} option while reading the excel file. – Chinmay Nayak Dec 04 '18 at 09:17

pandas dataframe ignoring zeros left side of column value

0 Answers0