To groupby columns and count the occurrences of each combination in Pandas, we use the DataFrame.groupby() with size(). The groupby() method separates the DataFrame into groups.At first, let us import the pandas library with an alias pd −import pandas as pdInitialize the data of lists −# initializing the data mylist = {'Car': ['BMW', 'Mercedes', 'Lamborgini', 'Audi', 'Mercedes', 'Porche', 'RollsRoyce', 'BMW'], 'Place': ['Delhi', 'Hyderabad', 'Chandigarh', 'Bangalore', 'Hyderabad', 'Mumbai', 'Mumbai', 'Delhi'], 'Sold': [95, 80, 80, 75, 90, 90, 95, 50 ]}Next, we will create a DataFrame −# DataFrame dataFrame = pd.DataFrame(mylist, columns=['Car', 'Place', 'Sold'])Now, use the groupby() to count the occurrence with ... Read More

When it is required to extracts elements from a list with digits in increasing order, a simple iteration, a flag value and the ‘str’ method is used.Below is a demonstration of the same −Example Live Demomy_list = [4578, 7327, 113, 3467, 1858] print("The list is :") print(my_list) my_result = [] for element in my_list:    my_flag = True    for index in range(len(str(element)) - 1):       if str(element)[index + 1]

When it is required to perform dual tuple alternate summation, a simple iteration and the modulus operator are used.Below is a demonstration of the same −Example Live Demomy_list = [(24, 11), (45, 66), (53, 52), (77, 51), (31, 10)] print("The list is :") print(my_list) my_result = 0 for index in range(len(my_list)):    if index % 2 == 0:       my_result += my_list[index][0]    else:       my_result += my_list[index][1] print("The result is :") print(my_result)OutputThe list is : [(24, 11), (45, 66), (53, 52), (77, 51), (31, 10)] The result is : 225ExplanationA list of ... Read More

When it is required to extract rear K digits from numbers, a simple list comprehension, the modulo operator and the ‘**’ operator are used.Below is a demonstration of the same −Example Live Demomy_list = [51645, 24567, 36743, 89452, 2122] print("The list is :") print(my_list) K = 3 print("The value of K is ") print(K) my_result = [element % (10 ** K) for element in my_list] print("The result is :") print(my_result)OutputThe list is : [51645, 24567, 36743, 89452, 2122] The value of K is 3 The result is : [645, 567, 743, 452, 122]ExplanationA list is defined and ... Read More

When it is required to combine list with other list elements, a simple iteration and ‘append’ method is used.Below is a demonstration of the same −Example Live Demomy_list_1 = [12, 14, 25, 36, 15] print("The first list is :") print(my_list_1) my_list_2 = [23, 15, 47, 12, 25] print("The second list is :") print(my_list_2) for element in my_list_2 :    my_list_1.append(element) print ("The result is :") print(my_list_1)OutputThe first list is : [12, 14, 25, 36, 15] The second list is : [23, 15, 47, 12, 25] The result is : [12, 14, 25, 36, 15, 23, 15, ... Read More

When it is required to sort matrix based upon sum of rows, a method is defined that uses ‘sum’ method to determine the result.Below is a demonstration of the same −Example Live Demodef sort_sum(row):    return sum(row) my_list = [[34, 51], [32, 15, 67], [12, 41], [54, 36, 22]] print("The list is :") print(my_list) my_list.sort(key = sort_sum) print("The result is :") print(my_list)OutputThe list is : [[34, 51], [32, 15, 67], [12, 41], [54, 36, 22]] The result is : [[12, 41], [34, 51], [54, 36, 22], [32, 15, 67]]ExplanationA method named ‘sort_sum’ is defined that takes a ... Read More

When it is required to sort by maximum digit in element, a method is defined that uses ‘str’ and ‘max’ method to determine the result.Below is a demonstration of the same −Example Live Demodef max_digits(element):    return max(str(element)) my_list = [224, 192, 145, 18, 3721] print("The list is :") print(my_list) my_list.sort(key = max_digits) print("The result is :") print(my_list)OutputThe list is : [224, 192, 145, 18, 3721] The result is : [224, 145, 3721, 18, 192]ExplanationA method named ‘max_digits’ is defined that takes element as a parameter, and converts it into a string, and then gets the maximum ... Read More

When it is required to calculate the percentage of positive elements of the list, a list comprehension and the ‘len’ method are used.Below is a demonstration of the same −Example Live Demomy_list = [14, 62, -22, 13, -87, 0, -21, 81, 29, 31] print("The list is :") print(my_list) my_result = (len([element for element in my_list if element > 0]) / len(my_list)) * 100 print("The result is :") print(my_result)OutputThe list is : [14, 62, -22, 13, -87, 0, -21, 81, 29, 31] The result is : 0ExplanationA list is defined and displayed on the console.A list comprehension is used ... Read More

When it is required to filter rows with range elements, a list comprehension and the ‘all’ operator is used to determine the output.Below is a demonstration of the same −Example Live Demomy_list = [[3, 2, 4, 5, 10], [32, 12, 4, 51, 10], [12, 53, 11], [2, 3, 31, 5, 8, 7]] print("The list is :") print(my_list) i, j = 2, 5 my_result = [index for index in my_list if all(element in index for element in range(i, j + 1))] print("The result is :") print(my_result)OutputThe list is : [[3, 2, 4, 5, 10], [32, 12, 4, 51, ... Read More

When it is required to sort strings by punctuation count, a method is defined that takes a string as a parameter and uses list comprehension and ‘in’ operator to determine the result.Below is a demonstration of the same −Example Live Demofrom string import punctuation def get_punctuation_count(my_str):    return len([element for element in my_str if element in punctuation]) my_list = ["python@%^", "is", "fun!", "to@#r", "@#$learn!"] print("The list is :") print(my_list) my_list.sort(key = get_punctuation_count) print("The result is :") print(my_list)OutputThe list is : ['python@%^', 'is', 'fun!', 'to@#r', '@#$learn!'] The result is : ['is', 'fun!', 'to@#r', 'python@%^', '@#$learn!']ExplanationThe required packages ... Read More