Indexing in PandasIndexing in pandas is an important topic that you need to know, as a data analyst or data […] November 24, 2024 in Python tagged pandas / indexing / reset / reindex / sort / index / Pandas Indexing by Mike
Customer Sales Ranking in TableauHow would you create a chart in Tableau that shows all of your customers ranked by sales, in […] August 9, 2024 in Data Visualization tagged sort / rank / ranking / chart / bar / report / Tableau / sales / Dashboard Customer by Mike
Add New Column of Incremental Numbers in pandasAre you working with a pandas DataFrame and do you want to add a new column of incremental […] April 9, 2024 in Python tagged rank / range / rating / rate / pandas / new / order / reorder / sort / incremental / add / column / pandas DataFrame by Mike
Sorting a pandas DataFrameYou can sort a pandas DataFrame by one or multiple (one or more) columns using sort_values() method and […] August 2, 2023 in Python tagged pandas / dataframe / ascending / descending / sort / sorting / multiple / columns / pandas DataFrame by Mike
Sorting Data in RTo sort data in R, we can use the arrange function. Let’s work with the Palmer penguins dataset. […] March 29, 2023 in R Language tagged gem / gems / by / arrange / manual / custom / gemstones / data / order / sort / frame by Mike
Transforming Data in RTransforming data is one of the steps in the Data Analytics/Analysis life cycle. In the Google Analytics Certificate […] March 11, 2023 in R Language tagged arrange / separate / mutate / unite / data / sort / frame / R by Mike
Cleaning Data in RNow we need to clean, standardize and manipulate our data. Usually, before we begin cleaning the data we […] March 11, 2023 in R Language tagged sort / max / R / rename / arrange / min / MEAN / order / summarize by Mike
Excel Sort FunctionThe new Excel SORT function is one of the new dynamic arrays that are available in Microsoft 365. […] February 12, 2023 in Excel tagged function / dynamic / sort / arrays by Mike
Sorted Data Validation ListIn Excel, in Microsoft 365, how do you sort your dropdown data validation list? You have a cell […] February 12, 2023 in Excel tagged dynamic / sort / data / list / array / validation by Mike
Excel SortingSorting a list or set of information can be straightforward or more complex. In Excel, you can sort […] February 6, 2023 in Excel tagged sort / sorting / arranging by Mike
Excel’s VSTACK FunctionCombining or appending data from multiple sheets is a common task in Excel. We’ll show you how you […] October 29, 2022 in Excel tagged VSTACK / excel / union / combine / sort by Mike
Excel Tables IntroductionWhat is an Excel table? Before answering that I will define the word tabular. If data is in […] September 5, 2022 in Excel tagged table / sort / tables / filter / Excel Tables by Mike