Use isinstance to Check Data TypeAre you a data professional working with a pandas dataset and have you found that one or more […] April 7, 2024 in Python tagged custom / data / function / type / object / isinstance by Mike
Data Imputation of AgeExploratory Data Analysis (EDA) has six main practices. The six main practices of EDA are discovering, structuring, cleaning, […] March 17, 2024 in Python tagged search / seaborn / replace / impute / clean / apply / python / missing / pandas / groupby / function / boxplot / Pandas EDA Cleaning by Mike
Apply a Custom Function to a DataFrameHow do we apply a custom Python function to a column in a pandas DataFrame? Here we’ll use […] August 3, 2023 in Python tagged column / apply / bar / progress / series / custom / dataframe / function / strip / new / assign / lambda / tqdm / add by Mike
The unite Function in RThe unite() method is used to merge two or more columns into a single column or variable. unite() […] March 31, 2023 in R Language tagged merge / concatenate / unite / combining / function / combine by Mike
The head Function in RWhen you exploring your data, try using the head function to see a few rows of your data. […] March 30, 2023 in R Language tagged function / head / R by Mike
glimpse Function in RWhen exploring your data, doing exploratory data analysis (EDA), the glimpse function is very handy. glimpse() is part […] March 30, 2023 in R Language tagged function / R / glimpse by Mike
1 The filter Function in RThe filter function allows us to only see rows of data that meet a certain condition. We end […] March 29, 2023 in R Language tagged function / filter by Mike
Table Function in RThe table() function in R can be used to quickly create frequency tables. You have rows and columns […] March 28, 2023 in R Language tagged function / table / R / histogram / frequency by Mike
Exploring Data in RIn the data analytics life cycle, in the second phase, you will be preparing your data. This involves […] March 12, 2023 in R Language tagged str / colnames / glimpse / function / column / select / structure / language / R / explore by Mike
Updating in R with mutateAre you needing to make some changes to your data frame in R language? Perhaps you need to […] March 11, 2023 in R Language tagged mutate / function 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
Excel SUMPRODUCT FunctionBelow is an example of the SUMPRODUCT function. SUMPRODUCT multiplies corresponding cells from multiple arrays and returns the […] December 4, 2022 in Excel tagged function / sumx / sumproduct by Mike