Dataframe Removes Zeros

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Dataframe Removes Zeros

scidam

Super Moderators

Posts: 818

Threads: 1

Joined: Mar 2018

Reputation: 111

Sep-17-2020, 12:47 PM

read_excel automatically converts to floats/integers, if look content that similar to floats/integers;
You can try to turn off such conversion by passing dtype=np.object argument to the read_excel function.

Find

Messages In This Thread

Dataframe Removes Zeros - by JoeDainton123 - Sep-16-2020, 07:03 PM

RE: Dataframe Removes Zeros - by bowlofred - Sep-16-2020, 07:31 PM

RE: Dataframe Removes Zeros - by scidam - Sep-17-2020, 12:47 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	-i option changes sys.path (removes leading empty string '')	markanth	6	1,995	Aug-26-2022, 09:27 PM Last Post: markanth
	remove zeros at the end of a number	Frankduc	7	2,182	Feb-25-2022, 03:48 PM Last Post: Frankduc
	The code I have written removes the desired number of rows, but wrong rows	Jdesi1983	0	1,637	Dec-08-2021, 04:42 AM Last Post: Jdesi1983
	Solving for zeros of an equation!	fmitchell17	0	1,843	Apr-05-2021, 07:49 PM Last Post: fmitchell17
	How to keep leading zeros with pandas?	eeps24	1	6,582	May-20-2020, 07:51 PM Last Post: deanhystad
	Why does pop() removes an element from more than one list?	albufork	5	2,868	Nov-17-2019, 08:01 AM Last Post: buran
	Probs with leading zeros falling away :-)	Badosc	2	2,887	Dec-04-2018, 08:57 PM Last Post: Badosc
	Controlling trailing zeros with rounding?	RedSkeleton007	1	24,513	Jan-25-2018, 07:23 AM Last Post: j.crater
	leading zeros	kerzol81	7	7,100	Apr-23-2017, 03:53 PM Last Post: kerzol81
	program is related to leading zeros	amrita	3	3,843	Apr-13-2017, 06:57 AM Last Post: wavic

Users browsing this thread: 1 Guest(s)

View a Printable Version

Dataframe Removes Zeros

User Panel Messages

Announcements