Reading Excel File via Pandas missing leading zeros [duplicate]

Question

with python I'm reading an excel file via pandas.

My problem is that I'm missing the leading zeros and I can't just fill them to a specific length because it always varies.

Example: 001,0001,0020

This is my code for reading the data:

def readDataFromFile(self, file):
        try:
            df = pd.read_excel(file)
            list = df.values.tolist()
            print(f'{file} >> Read')
            return list
        except:
            print('No input or wrong input given')
            return

Corralien · Accepted Answer · 2023-01-30 09:52:39Z

1

Use dtype as parameter of read_excel function to prevent pandas from converting string to number:

df = pd.read_excel(file, dtype={'your_column': str})

Without dtype:

>>> pd.read_excel(file)
   your_column
0            1
1            1
2           20

With dtype:

>>> pd.read_excel(file, dtype={'your_column': str})
  your_column
0         001
1        0001
2        0020

answered Jan 30, 2023 at 9:52

Corralien

121k8 gold badges44 silver badges69 bronze badges

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

Collectives™ on Stack Overflow

Reading Excel File via Pandas missing leading zeros [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related