Duration: 0:00

4 views

1

Data Grouping and Sorting

Data Grouping
Data grouping is the process of categorizing data into groups based on common characteristics or attributes. This helps to summarize and analyze data more effectively.

Example of Data Grouping
Suppose we have a dataset of sales data with columns for region, product, and sales amount. We can group the data by region to calculate the total sales for each region.
Region Sales Amount
North 1000
North 500
South 800
South 1200
East 1500
Grouped by Region:
Region Total Sales
North 1500
South 2000
East 1500
Data Sorting
Data sorting is the process of arranging data in a specific order, either ascending or descending, based on one or more columns.

Example of Data Sorting
Suppose we have a dataset of employee information with columns for name, age, and salary. We can sort the data by salary in descending order to identify the highest-paid employees.
Name Age Salary
John 30 50000
Jane 25 60000
Bob 40 40000
Alice 35 70000
Sorted by Salary (Descending):
Name Age Salary
Alice 35 70000
Jane 25 60000
John 30 50000
Bob 40 40000