Data extraction from a table based on column and row names

Thread Rating:

Thread Modes

Data extraction from a table based on column and row names

buran

Posts: 8,090

Threads: 154

Joined: Sep 2016

Reputation: 582

Jan-09-2021, 10:04 PM

print(df['Letzter'][df['Handelsplatz']=='NYSE'])
# or
print(df.query('Handelsplatz=="NYSE"')['Letzter'])

tgottsc1 likes this post

If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Messages In This Thread

RE: Data extraction from a table based on column and row names - by buran - Jan-09-2021, 10:04 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Returning Column and Row Data From Spreadsheet	knight2000	0	438	Oct-22-2023, 07:07 AM Last Post: knight2000
	Using pyodbc&pandas to load a Table data to df	tester_V	3	819	Sep-09-2023, 08:55 PM Last Post: tester_V
	Find a string from a column of one table in another table	visedwings049	8	1,176	Sep-07-2023, 03:22 PM Last Post: deanhystad
	Color a table cell based on specific text	Creepy	11	1,987	Jul-27-2023, 02:48 PM Last Post: deanhystad
	Database that can compress a column, or all data, automatically?	Calab	3	1,173	May-22-2023, 03:25 AM Last Post: Calab
	Code for pullng all data in a column	EmBeck87	5	1,109	Apr-03-2023, 03:43 PM Last Post: deanhystad
	Grouping Data based on 30% bracket	purnima1	4	1,195	Mar-10-2023, 07:38 PM Last Post: deanhystad
	create new column based on condition	arvin	12	2,246	Dec-13-2022, 04:53 PM Last Post: jefsummers
	How to assign a value to pandas dataframe column rows based on a condition	klllmmm	0	833	Sep-08-2022, 06:32 AM Last Post: klllmmm
	conditionals based on data frame	mbrown009	1	897	Aug-12-2022, 08:18 AM Last Post: Larz60+

Users browsing this thread: 2 Guest(s)