Stop Pandas from Showing Large Numbers in Scientific Notation

1. Introduction

A user asked why the Pandas column '区划编码' still appears in scientific notation after replacing the value 420113000000 with a quoted string.

The issue occurs because Pandas treats the column as a numeric type, so large numbers are automatically formatted in scientific notation.

2. Solution

Convert the column to string type before performing the replacement. This ensures the value is handled as text and displayed normally.

df['区划编码'] = df['区划编码'].astype(str).replace('420113000000', "'420113000000'")

The astype(str) call changes every entry in the column to a string, after which the replace operation works on string values.

When the column is already a string, you should replace the value without adding extra quotes around it. Use the plain string '420113000000' as the replacement.

df['区划编码'] = df['区划编码'].replace('420113000000', "O'420113000000")

In this example the replacement value contains an internal apostrophe, which is represented by two single quotes in the string literal.

3. Summary

By explicitly converting the column to str and using the correct replacement syntax, the large code displays as a normal string instead of scientific notation, solving the original problem.