Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Programming Articles
Page 316 of 2547
Create a Pivot Table with multiple columns – Python Pandas
A pivot table is a data summarization tool that reorganizes and aggregates data. In Pandas, you can create pivot tables with multiple columns using the pandas.pivot_table() function to create a spreadsheet-style pivot table as a DataFrame. Syntax pandas.pivot_table(data, index=None, columns=None, values=None, aggfunc='mean') Creating a DataFrame Let's start by creating a DataFrame with team records ? import pandas as pd # Create DataFrame with Team records dataFrame = pd.DataFrame({ 'Team ID': {0: 5, 1: 9, 2: 6, 3: 11, 4: 2, 5: 7}, 'Team ...
Read MorePython - Calculate the minimum of column values of a Pandas DataFrame
To find the minimum value in a Pandas DataFrame column, use the min() function. This method works on individual columns or across the entire DataFrame. Basic Syntax The basic syntax for finding minimum values is ? # For a single column df['column_name'].min() # For all numeric columns df.min() Example 1: Finding Minimum in a Single Column Let's create a DataFrame and find the minimum value in the "Units" column ? import pandas as pd # Create DataFrame1 dataFrame1 = pd.DataFrame({ "Car": ['BMW', 'Lexus', 'Audi', 'Tesla', ...
Read MoreHow to exponentially scale the Y axis with matplotlib?
To exponentially scale the Y-axis with matplotlib, you can use the yscale() function with different scale types. The most common approach is using symlog (symmetric logarithmic) scaling, which handles both positive and negative values effectively. Basic Exponential Y-axis Scaling Here's how to create a plot with exponential Y-axis scaling ? import numpy as np import matplotlib.pyplot as plt # Set figure size plt.rcParams["figure.figsize"] = [7.00, 3.50] plt.rcParams["figure.autolayout"] = True # Create data points dt = 0.01 x = np.arange(-50.0, 50.0, dt) y = np.arange(0, 100.0, dt) # Plot the data plt.plot(x, y) ...
Read MorePython - Convert List of lists to List of Sets
Converting a list of lists to a list of sets is useful for removing duplicates from each inner list while maintaining the outer structure. Python provides several approaches using map(), list comprehensions, and loops. Using map() Function The map() function applies the set() constructor to each inner list ? my_list = [[2, 2, 2, 2], [1, 2, 1], [1, 2, 3], [1, 1], [0]] print("The list of lists is:") print(my_list) my_result = list(map(set, my_list)) print("The resultant list is:") print(my_result) The list of lists is: [[2, 2, 2, 2], [1, 2, ...
Read MorePython program to get all subsets having sum s
When working with lists, you might need to find all subsets that sum to a specific value. Python's itertools.combinations provides an efficient way to generate all possible subsets and check their sums. Using itertools.combinations The combinations function generates all possible subsets of different sizes from the input list ? from itertools import combinations def find_subsets_with_sum(arr, target_sum): result = [] # Generate subsets of all possible sizes (0 to len(arr)) for size in range(len(arr) + 1): ...
Read MorePython - Filter Rows Based on Column Values with query function in Pandas?
To filter rows based on column values, we can use the query() function. In the function, set the condition through which you want to filter records. At first, import the required library − import pandas as pd Following is our data with Team Records − team = [['India', 1, 100], ['Australia', 2, 85], ['England', 3, 75], ['New Zealand', 4, 65], ['South Africa', 5, 50], ['Bangladesh', 6, 40]] Create a DataFrame from above and add columns as well − dataFrame = pd.DataFrame(team, ...
Read MorePython - Find all the strings that are substrings to the given list of strings
Finding strings that are substrings of other strings in a list is a common task in Python. We can use different approaches including list comprehensions with in operator and the any() function. Using List Comprehension with in Operator This approach checks if each string from one list appears as a substring in any string from another list ? main_strings = ["Hello", "there", "how", "are", "you"] search_strings = ["Hi", "there", "how", "have", "you", "been"] print("Main strings:", main_strings) print("Search strings:", search_strings) # Find strings from search_strings that are substrings of any string in main_strings result = ...
Read MorePython program to print sorted number formed by merging all elements in array
When it is required to print the sorted numbers that are formed by merging all elements in an array, we can use string manipulation and sorting techniques. The approach involves converting all numbers to strings, joining them together, sorting the digits, and converting back to an integer. Example Below is a demonstration of the same − def get_sorted_nums(my_num): my_num = ''.join(sorted(my_num)) my_num = int(my_num) print(my_num) def merged_list(my_list): my_list = list(map(str, my_list)) my_str = ''.join(my_list) ...
Read MorePython Pandas – Can we use & Operator to find common columns between two DataFrames?
Yes, we can use the & operator to find the common columns between two DataFrames. The & operator performs a set intersection operation on DataFrame column indexes, returning only the columns that exist in both DataFrames. Creating Two DataFrames Let's create two DataFrames with some overlapping columns − import pandas as pd # Creating dataframe1 dataFrame1 = pd.DataFrame({ "Car": ['BMW', 'Lexus', 'Tesla', 'Mustang', 'Mercedes', 'Jaguar'], "Cubic_Capacity": [2000, 1800, 1500, 2500, 2200, 3000], }) print("Dataframe1...", dataFrame1) # Creating dataframe2 dataFrame2 = pd.DataFrame({ ...
Read MorePython Program to print all distinct uncommon digits present in two given numbers
When it is required to print all the distinct uncommon digits that are present in two numbers, a method is defined that takes two integers as parameters. The method symmetric_difference() is used to get the uncommon digits that exist in one number but not in both. What are Uncommon Digits? Uncommon digits are digits that appear in one number but not in the other. For example, in numbers 567234 and 87953573214, the uncommon digits are 1, 6, 8, and 9. Example Below is a demonstration of finding distinct uncommon digits ? def distinct_uncommon_nums(val_1, val_2): ...
Read More