/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

4 votes292 views4 answers
Asyncio sleep
Python
0 vote281 views1 answer
How to make a numpy array of certain values
Python
0 vote291 views1 answer
How to add a name or a number to a list in python
Python
2 votes255 views1 answer
Pandas append index ignore
Python
0 vote247 views1 answer
Python : a counter
Python
3 votes269 views1 answer
Pandas groupby column count distinct values
Python
16 votes291 views6 answers
Pandas python install
Python
0 vote268 views1 answer
Comment all selected lines in python
Python
1 vote317 views1 answer
Open a filename starting with in python
Python
8 votes279 views2 answers
Add empty column to dataframe pandas
Python