Indexing in Pandas
Indexing in pandas is an important topic that you need to know, as a data analyst or data […]
sort
Customer Sales Ranking in Tableau
How would you create a chart in Tableau that shows all of your customers ranked by sales, in […]
Add New Column of Incremental Numbers in pandas
Are you working with a pandas DataFrame and do you want to add a new column of incremental […]
Sorting a pandas DataFrame
You can sort a pandas DataFrame by one or multiple (one or more) columns using sort_values() method and […]
Sorting Data in R
To sort data in R, we can use the arrange function. Let’s work with the Palmer penguins dataset. […]
Transforming Data in R
Transforming data is one of the steps in the Data Analytics/Analysis life cycle. In the Google Analytics Certificate […]
Cleaning Data in R
Now we need to clean, standardize and manipulate our data. Usually, before we begin cleaning the data we […]
Excel Sort Function
The new Excel SORT function is one of the new dynamic arrays that are available in Microsoft 365. […]
Sorted Data Validation List
In Excel, in Microsoft 365, how do you sort your dropdown data validation list? You have a cell […]
Excel Sorting
Sorting a list or set of information can be straightforward or more complex. In Excel, you can sort […]
Excel’s VSTACK Function
Combining or appending data from multiple sheets is a common task in Excel. We’ll show you how you […]
Excel Tables Introduction
What is an Excel table? Before answering that I will define the word tabular. If data is in […]