Indexing by label with rows and columns at the same time

Question

I want to get values of two or more different column in form of tuple

def top():
    Top15 = answer_one()
    x = Top15.loc[Top15['% Renewable'].idxmax()]
    return x.loc['% Renewable' , 'Country']

I want to get values of column named % Renewable and Country in form of a tuple

@: Aditya, Welcome to SO site, However, the best practice to get answer is to show the Dataset or Dataframe you have or few line of data at least to reproduce. — Karn Kumar, Jan 23 '19 at 13:33

score 2 · Answer 1 · answered Jan 23 '19 at 13:32

2

pd.DataFrame.loc supports indexing by row and column labels simultaneously:

df = pd.DataFrame({'A': [1, 2], 'B': [3, 4]})

res = tuple(df.loc[df['A'].idxmax(), ['A', 'B']])    # (2, 4)

Or if list is sufficient:

res = df.loc[df['A'].idxmax(), ['A', 'B']].tolist()  # [2, 4]

answered Jan 23 '19 at 13:32

jpp

1

Good example set @jpp. – Karn Kumar Jan 23 '19 at 13:45
After using the 'list' I am getting output [nan, 69.64803] although the name of country is available – Aditya Jan 23 '19 at 13:47
@Aditya, Sorry, can't help further without a [mcve]. – jpp Jan 23 '19 at 13:47
how can i upload my dataset – Aditya Jan 23 '19 at 14:02
@Aditya, [How to make good reproducible pandas examples](https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples) – jpp Jan 23 '19 at 14:23

1 Answers1