python – join two columns and transform it as index

ByAnurag batra September 26, 2022September 6, 2022

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]

Here is what the above code is Doing:
1. Create a DataFrame with 3 columns and 3 rows.
2. Define the columns to combine.
3. Create a new column called ‘combined’ that combines the values of the columns defined in step 2.
4. Set the index to the ‘combined’ column.
5. Set the index name to None.

how to move the element of an array in python by one step

Python Examples

how to move the element of an array in python by one step

ByAnurag batra September 27, 2022September 6, 2022

def shift(key, array): counter = range(len(array)-1) new = counter for i in counter: new[i] = array[i-key] return new print shift(1, [5, 6, 7]) Here is what the above code is Doing: 1. It creates a range of numbers from 0 to the length of the array minus 1. 2. It creates a new array of…

Python Examples

how to pass primary key to url django

ByAnurag batra October 19, 2022September 6, 2022

{{ post.category }} Here is what the above code is Doing: 1. We’re using the {% url %} template tag to get the URL for the category_detail view. 2. We’re passing the category’s primary key to the view as the pk argument. 3. We’re using the category’s name as the link text.

Python Examples

pandas series remove element by index

ByAnurag batra October 16, 2022September 6, 2022

new_series = series.drop(list_of_indexes_to_be_dropped); Here is what the above code is Doing: 1. We are creating a list of indexes to be dropped. 2. We are dropping the indexes from the series. 3. We are storing the new series in a new variable.

Python Examples

install python 3.6 on centos

ByAnurag batra August 4, 2022June 30, 2022

yum install -y python3 Here is what the above code is Doing: 1. Install the EPEL repository 2. Install the Python 3 package

how to convert an image to matrix in python

Python Examples

how to convert an image to matrix in python

ByAnurag batra October 16, 2022September 6, 2022

import matplotlib.image as image img=image.imread(‘image_name.png’) print(‘The Shape of the image is:’,img.shape) print(‘The image as array is:’) print(img) Here is what the above code is Doing: 1. We are importing the image module from the matplotlib library. 2. We are reading the image using the imread() function. 3. We are printing the shape of the image…

Python Examples

round numbers python

ByAnurag batra April 16, 2022April 12, 2022

>>> import math >>> math.ceil(5.2) 6 >>> math.ceil(5) 5 >>> math.ceil(-0.5) 0 Here is what the above code is Doing: 1. We are first importing the math module. 2. We are then using the ceil() function from the math module to round up the number 5.2 to the next highest integer, which is 6. 3. We are then…

Similar Posts