Obtain data from pandas dataframe based on the column containing column names provided at each record

Asked Apr 24 '19 at 02:06

Active Apr 24 '19 at 02:06

Viewed 16 times

I have a 'data' dataframe that contain col_names that have various column names within that dataframe. I need a new column corresponding to col_names for each row. In the following example, the new column (say D) should have 2 and 30 for first and second records respectively

import pandas as pd 

# Initialise data to lists. 
data = [{'col_names': 'b', 'b': 2, 'c':3}, {'col_names':'c', 'b': 20, 'c': 30}] 

df = pd.DataFrame(data)

asked Apr 24 '19 at 02:06

Praveen Gupta Sanka

1

Use `df.lookup()`. – cs95 Apr 24 '19 at 02:08
What values will go in that column? – Daniel Butler Apr 24 '19 at 02:09
@Daniel Butler - df.lookup() actually answers my question. In the new column, the values corresponding the column name in the 'col_names' should be present for each row. – Praveen Gupta Sanka Apr 24 '19 at 02:27

Obtain data from pandas dataframe based on the column containing column names provided at each record

0 Answers0