python - Avoiding Excel's Scientific Notation Rounding when Parsing with Pandas -
i have excel file produced automatically occasional large numbers 135061808695
. in excel file when click on cell shows full number 135061808695
visually automatic "general" format number appears 1.35063e+11
.
when use excelfile
in pandas pulls value in scientific notation 1.350618e+11
instead of full 135061808695
. there way pandas pull full value without going in messing excel file?
pandas might pulling full value not showing in default output:
df = pd.dataframe({ 'x':[135061808695.] }) df.x 0 1.350618e+11 name: x, dtype: float64
standard python format:
print "%15.0f" % df.x 135061808695
or in pandas, convert integer type integer formatting:
df.x.astype(np.int64) 0 135061808695 name: x, dtype: int64
Comments
Post a Comment