/Python/Python - join two columns and transform it as index

Python - join two columns and transform it as index

df = DataFrame({'var_1':['a','b','c'], 'var_2':[1, 2, 3], 'var_3':['apple', 'banana', 'pear']})
cols = ['var_1', 'var_2']    # Set columns to combine
df['combined'] = df[cols].apply(lambda row: ', '.join(row.values.astype(str)), axis=1)

# Define which column is index
df_i = df.set_index('combined') 

# Set the index to None
df_i.index.names = [None]

Source: stackoverflow.com

Similar codes

0 vote156 views1 answer
Pandas read csv dtype list
Python
2 votes152 views2 answers
Python add list to dictionary in loop
Python
0 vote149 views1 answer
Iterate over meta tag python
Python
3 votes159 views1 answer
Maping value to data in pandas dataframe
Python
3 votes157 views1 answer
Knowing the sum of null value is pandas dataframe
Python
16 votes187 views4 answers
Dataframe find nan rows
Python
1 vote167 views10 answers
Recursion
Python
3 votes152 views2 answers
Moving element to last position in a list python
Python
11 votes162 views2 answers
Cross validation python
Python
80 votes155 views4 answers
Save pandas into csv
Python