/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

3 votes238 views1 answer
Update all modules python in cmd
Python
0 vote262 views1 answer
Fast comand exit python windows
Python
20 votes242 views1 answer
ParserError: Error tokenizing data. C error: Expected 1 fields in line 87, saw 2
Python
0 vote249 views1 answer
Anvil get last row of data table
Python
0 vote246 views1 answer
Python readlines end of file
Python
0 vote278 views1 answer
How to remove explicit string concatenation
Python
1 vote270 views1 answer
Pathlib path exists
Python
0 vote255 views1 answer
How to add the sum of multiple columns into another column in a dataframe
Python
0 vote240 views1 answer
How to import files from desktop to python
Python
0 vote256 views2 answers
Leer fichero de texto con columnas como diccionario python
Python