ゼロ埋めした数字が読み込むと同時に消える現象が発生。
型指定して読み込もうとしたが、dtype='object'のオプションをつけるのでも対応できる。
xlsx = pd.read_excel(excel_path + fileName + '.xlsx', dtype='object')
Python: Keep leading zeroes when converting from excel to CSV with pandas
More than 3 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme