[Pandas] Write data to Excel with dot decimals

Thread Rating:

Thread Modes

[Pandas] Write data to Excel with dot decimals

ibreeden
Verb Conjugator

Posts: 584

Threads: 1

Joined: Aug 2019

Reputation: 56

May-05-2021, 05:28 PM

It is an Excel setting which defines how numbers are shown: with a decimal point or a decimal comma.
It is described here: Change the decimal point to a comma or vice versa.

Messages In This Thread

RE: [Pandas] Write data to Excel with dot decimals - by ibreeden - May-05-2021, 05:28 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Pandas keep existing format of Excel	AlphaInc	2	1,061	Jan-11-2024, 03:44 AM Last Post: plonkarchivist
	Grouping in pandas/multi-index data frame	Aleqsie	3	688	Jan-06-2024, 03:55 PM Last Post: deanhystad
	Write from dictionary to excel	divon	3	3,782	Jun-11-2023, 10:37 AM Last Post: Larz60+
	Data Sorting and filtering(From an Excel File)	PY_ALM	0	1,051	Jan-09-2023, 08:14 PM Last Post: PY_ALM
	Increase df column values decimals	SriRajesh	2	1,112	Nov-14-2022, 05:20 PM Last Post: deanhystad
	How to further boost the data read write speed using pandas	tjk9501	1	1,269	Nov-14-2022, 01:46 PM Last Post: jefsummers
	Split excel file and write output at specific row and set sheet position	DSCA	0	1,999	May-12-2022, 07:29 PM Last Post: DSCA
	can't access data from URL in pandas/jupyter notebook	aaanoushka	1	1,868	Feb-13-2022, 01:19 PM Last Post: jefsummers
	Help with poorly formatted excel data	armitron121	1	1,729	Jan-13-2022, 07:31 AM Last Post: paul18fr
	Sorting data with pandas	TheZaind	4	2,355	Nov-22-2021, 07:33 PM Last Post: aserian

Users browsing this thread: 2 Guest(s)