Difference of two columns in Pandas dataframe

Thread Rating:

Thread Modes

Difference of two columns in Pandas dataframe

zinho
Not Blown Up Yet

Posts: 56

Threads: 19

Joined: Jan 2017

Reputation: 0

Jun-17-2020, 03:36 PM

My question is solved now, thank you
I miss this

ndf = xw.Range('AI1:AJ' + str(len(last_row))).options(pd.DataFrame).value

Would be this

ndf = xw.Range('AI1:AJ' + str(len(last_row))).options(pd.DataFrame, index=False).value

Messages In This Thread

RE: Difference of two columns in Pandas dataframe - by zinho - Jun-17-2020, 03:36 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	How to add columns to polars dataframe	sayyedkamran	1	1,767	Nov-03-2023, 03:01 PM Last Post: gulshan212
	concat 3 columns of dataframe to one column	flash77	2	841	Oct-03-2023, 09:29 PM Last Post: flash77
	HTML Decoder pandas dataframe column	mbrown009	3	1,029	Sep-29-2023, 05:56 PM Last Post: deanhystad
	Use pandas to obtain cartesian product between a dataframe of int and equations?	haihal	0	1,118	Jan-06-2023, 10:53 PM Last Post: haihal
	Pandas Dataframe Filtering based on rows	mvdlm	0	1,432	Apr-02-2022, 06:39 PM Last Post: mvdlm
	Pandas dataframe: calculate metrics by year	mcva	1	2,312	Mar-02-2022, 08:22 AM Last Post: mcva
	Pandas dataframe comparing	anto5	0	1,261	Jan-30-2022, 10:21 AM Last Post: anto5
	PANDAS: DataFrame \| Replace and others questions	moduki1	2	1,797	Jan-10-2022, 07:19 PM Last Post: moduki1
	PANDAS: DataFrame \| Saving the wrong value	moduki1	0	1,551	Jan-10-2022, 04:42 PM Last Post: moduki1
	update values in one dataframe based on another dataframe - Pandas	iliasb	2	9,260	Aug-14-2021, 12:38 PM Last Post: jefsummers

Users browsing this thread: 2 Guest(s)