How to ger matching rows data based on index columns

Thread Rating:

Thread Modes

How to ger matching rows data based on index columns

scidam

Super Moderators

Posts: 818

Threads: 1

Joined: Mar 2018

Reputation: 111

Mar-08-2019, 11:05 AM

I didn't try it, but I think it should be something like this:

df1.ix[df2.index].dropna()

Messages In This Thread

RE: How to ger matching rows data based on index columns - by scidam - Mar-08-2019, 11:05 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Matching Data - Help - Dictionary	manuel174102	1	425	Feb-02-2024, 04:47 PM Last Post: deanhystad
	how do you style data frame that has empty rows.	gsaray101	0	544	Sep-08-2023, 05:20 PM Last Post: gsaray101
	Grouping Data based on 30% bracket	purnima1	4	1,237	Mar-10-2023, 07:38 PM Last Post: deanhystad
	Converting a json file to a dataframe with rows and columns	eyavuz21	13	4,683	Jan-29-2023, 03:59 PM Last Post: eyavuz21
	(Python) Pulling data from UA Google Analytics with more than 100k rows into csv.	Stockers	0	1,269	Dec-19-2022, 11:11 PM Last Post: Stockers
	Extracting Data into Columns using pdfplumber	arvin	17	5,704	Dec-17-2022, 11:59 AM Last Post: arvin
	How to properly format rows and columns in excel data from parsed .txt blocks	jh67	7	1,948	Dec-12-2022, 08:22 PM Last Post: jh67
	Check DataFrames with different sorting in columns and rows	Foxyskippy	0	806	Nov-19-2022, 07:49 AM Last Post: Foxyskippy
	Deleting rows based on cell value in Excel	azizrasul	11	2,731	Oct-19-2022, 02:38 AM Last Post: azizrasul
	How to assign a value to pandas dataframe column rows based on a condition	klllmmm	0	870	Sep-08-2022, 06:32 AM Last Post: klllmmm

Users browsing this thread: 2 Guest(s)