Insightful Analytics
Krunal Lathiya 
In R, you can think of a vector as a series of values in a single column. It contains the same data type. Each column of a data frame is a vector. So, if I have several vectors, I can combine them and create a data frame out of them. To create a data frame … Read more
The dplyr filter() function in R subsets a data frame and retains all rows that satisfy the conditions. In other words, you can select the data frame rows based on conditions. To retain rows, they should produce the output to TRUE, and if they return NA, they will be dropped from the data frame. Syntax … Read more
The dplyr::distinct() function in R removes duplicate rows from a data frame or tibble and keeps unique rows. You can provide additional arguments, like columns, to check for duplicates in those specific columns. Syntax distinct(.data, …, .keep_all = FALSE) Parameters Argument Description .data It is an input data frame or tibble from which to remove duplicate … Read more
NA values are missing values. They are somehow absent from a data frame. Before creating a model based on a data frame, we need to clean the data frame from missing values, and it depends on different scenarios. Here are four different ways for different scenarios to remove NA values from a data frame: Use … Read more
The append() function in R concatenates values to a vector or list at a specified position. It returns a new object without modifying the original. You can add a single or multiple elements to a vector or list. Syntax append(obj, values, after = length(x)) Parameters Name Value obj It is an original vector or list. … Read more
NULL represents a null object, and sometimes, it’s logical for the project to filter it out from either a list or data frame. Here are three ways to remove NULL values from a list in R: Using Filter() with Negate() and is.null() Using sapply() or lapply() with Subsetting Using purrr::discard() (Tidyverse Approach) For example, if … Read more
In a real-life dataset, the last row may contain metadata, summaries, footnotes, or unwanted rows that are not needed for data analysis. That’s why we need to clean the data. Data cleaning requires removing unnecessary rows from the data frame for data accuracy and integrity. We have already seen how to remove the first row … Read more
When we attempt to remove the first row of a data frame, we are essentially selecting all the rows except for the first one. This means we are excluding the first row and retrieving all other rows in the data frame. DataFrames are like tables with rows and columns. To remove rows, you can use … Read more
The basename() is a base R function that extracts the last component (or the ‘base name’) of a file or directory path and returns the name of the file or directory. So, if you have a path like “/Users/krunallathiya/Desktop/Code/pypro/data.pdf,“ basename() would return “data.pdf.“ The opposite function of basename() is dirname(), which gives the directory part of the path. Syntax basename(path) … Read more
To grow the list, you can add an element (numeric value, character vectors, other lists, data frames, or functions) at whichever position you like. You can add a single element, multiple elements, or a list as an element. The final way depends on the user’s intention. Here are five ways to append an element to … Read more
