To create a subset of columns, we can use filter(). Through this, we can filter column values with similar pattern using like operator. At first, let us create a DataFrame with 3 columns −dataFrame = pd.DataFrame({"Product": ["SmartTV", "ChromeCast", "Speaker", "Earphone"], "Opening_Stock": [300, 700, 1200, 1500], "Closing_Stock": [200, 500, 1000, 900]})Now, let us create a subset with multiple columns −dataFrame[['Opening_Stock', 'Closing_Stock']]Create a subset with similarly patterned names −dataFrame.filter(like='Open')ExampleFollowing is the complete code −import pandas as pd dataFrame = pd.DataFrame({"Product": ["SmartTV", "ChromeCast", "Speaker", "Earphone"], "Opening_Stock": [300, 700, 1200, 1500], "Closing_Stock": [200, 500, 1000, 900]}) print"DataFrame...", dataFrame print"Displaying a subset ... Read More

To get column index from column name in Python Pandas, we can use the get_loc() method.Steps −Create a two-dimensional, size-mutable, potentially heterogeneous tabular data, df.Print the input DataFrame, df.Find the columns of DataFrame, using df.columns.Print the columns from Step 3.Initialize a variable column_name.Get the location, i.e., of index for column_name.Print the index of the column_name.Example −import pandas as pd df = pd.DataFrame(    {       "x": [5, 2, 7, 0],       "y": [4, 7, 5, 1],       "z": [9, 3, 5, 1]    } ) print"Input DataFrame 1 is:", df columns = ... Read More

When it is required to construct equi-digit tuples, the ‘//’ operator and the list slicing is used.ExampleBelow is a demonstration of the samemy_list = [5613, 1223, 966143, 890, 65, 10221] print("The list is :") print(my_list) my_result = [] for sub in my_list: mid_index = len(str(sub)) // 2 element_1 = str(sub)[:mid_index] element_2 = str(sub)[mid_index:] my_result.append((int(element_1), int(element_2))) print("The resultant list is :") print(my_result)OutputThe list is : [5613, 1223, 966143, 890, 65, 10221] The resultant list is : [(56, 13), (12, 23), (966, 143), (8, 90), ... Read More

When it is required to omit K length rows, a simple iteration and the ‘len’ method along with ‘append’ method are used.ExampleBelow is a demonstration of the samemy_list = [[41, 7], [8, 10, 12, 8], [10, 11], [6, 82, 10]] print("The list is :") print(my_list) my_k = 2 print("The value of K is ") print(my_k) my_result = [] for row in my_list: if len(row) != my_k : my_result.append(row) print("The resultant list is :") print(my_result)OutputThe list is : [[41, 7], [8, 10, 12, 8], [10, 11], [6, ... Read More

When it is required to extract rows with common difference elements, an iteration and a flag value is used.ExampleBelow is a demonstration of the samemy_list = [[31, 27, 10], [8, 11, 12], [11, 12, 13], [6, 9, 10]] print("The list is :") print(my_list) my_result = [] for row in my_list:    temp = True    for index in range(0, len(row) - 1): if row[index + 1] - row[index] != row[1] - row[0]: temp = False ... Read More

When it is required to compute a polynomial equation, a simple iteration along with the ‘*’ operator is used.ExampleBelow is a demonstration of the samemy_list = [3, -6, 3, -1, 23, -11, 0, -8] print("The list is :") print(my_list) x = 3 my_list_length = len(my_list) my_result = 0 for i in range(my_list_length): my_sum = my_list[i] for j in range(my_list_length - i - 1): my_sum = my_sum * x my_result = my_result + my_sum print("The result is :") print(my_result)OutputThe list ... Read More

When it is required to test if a tuple list contains a single element, a flag value and a simple iteration is used.ExampleBelow is a demonstration of the samemy_list = [(72, 72, 72), (72, 72), (72, 72)] print("The list is :") print(my_list) my_result = True for sub in my_list:    flag = True    for element in sub:       if element != my_list[0][0]:          flag = False          break    if not flag:       my_result = False       break if(flag == True): ... Read More

When it is required to redistribute the trimmed values, a list comprehension and the ‘/’ operator are used.ExampleBelow is a demonstration of the samemy_list = [11, 26, 24, 75, 96, 37, 48, 29, 93] print("The list is :") print(my_list) key = 2 print("The value of key is") print(key) full_sum = sum(my_list) trimmed_list = my_list[key:len(my_list) - key] trim_sum = sum(trimmed_list) add_value = (full_sum - trim_sum) / len(trimmed_list) result = [ele + add_value for ele in trimmed_list] print("The resultant list is:") print(result)OutputThe list is : [11, 26, 24, 75, 96, 37, 48, 29, 93] The value of ... Read More

When it is required to get the count of consecutive identical elements in a list, an iteration, the ‘append’ method, and the ‘set’ method are used.ExampleBelow is a demonstration of the samemy_list = [24, 24, 24, 15, 15, 64, 64, 71, 13, 95, 100] print("The list is :") print(my_list) my_result = [] for index in range(0, len(my_list) - 1): if my_list[index] == my_list[index + 1]: my_result.append(my_list[index]) my_result = len(list(set(my_result))) print("The result is :") print(my_result)OutputThe list is : [24, 24, 24, 15, 15, 64, 64, 71, 13, ... Read More

When it is required to give the rows with all list elements, a flag value, a simple iteration and the ‘append’ method is used.ExampleBelow is a demonstration of the samemy_list = [[8, 6, 3, 2], [1, 6], [2, 1, 7], [8, 1, 2]] print("The list is :") print(my_list) sub_list = [1, 2] result = [] for row in my_list: flag = True for element in sub_list: if element not in row: flag = False ... Read More