If we have string data stored in R data frame columns then we might want to sort the data frame rows in alphabetical order. This can be done with the help of apply and sort function inside transpose function.For example, if we have a data frame called df that contains string data then sorting of df in alphabetical order can be done by using the below given command −t(apply(df,1,sort))Example 1Following snippet creates a sample data frame −x1

To find the percentage of missing values in each column of an R data frame, we can use colMeans function with is.na function. This will find the mean of missing values in each column. After that we can multiply the output with 100 to get the percentage.Check out the below given examples to understand how it can be done.Example 1Following snippet creates a sample data frame −x1

To count the number of times a value occurs in a column of an R data frame, we can use table function for that particular column.For example, if we have a data frame called df that contains a column say Response then finding the number of times a value occurs in Response can be found by using the command given below −table(df$Response)Example 1Following snippet creates a sample data frame −x

To add columns with square of each column in R data frame, we can use setNames function and cbind function for squaring each value. This might be required when we want to use squared form of variables in the data analysis.Check out the below given examples to understand how it can be done.Example 1Following snippet creates a sample data frame −x1

To remove first few rows from each group in R, we can use slice function of dplyr package after grouping with group_by function.For example, if we have a data frame called df that contains a grouping column say Grp then we remove first 2 rows from each group by using the command given below −df%>%group_by(Grp)%>%slice(3:n())Example 1Following snippet creates a sample data frame −Group

To create boxplot of grouped data in R, we would first need to convert the grouped data into complete data by repeating the values up to the frequency/count for each value and then use the boxplot function on the complete data.Check out the below example to understand how it can be done.ExampleFollowing snippet creates a sample data frame −Group

To display mean value with underline in base R plot, we can use underline function within text function. The text function will be used to write the word Mean in the plot and underline function will underline the mean.Check out the below example to understand how it works.ExampleFollowing snippet creates a sample data frame −x

When we do not pass any title for X-axis then the default is Index and if we want to remove it then xlab argument needs to be used inside the plot function.For example, if we want to create a plot of first hundred values without Index on X-axis then we can use the command mentioned below − plot(1:100, xlab="")ExampleTo remove Index in base R plot, use the code given below −plot(1:10) OutputIf you execute the above given code, it generates the following output −To remove Index in base R plot, add the following code to the above code −plot(1:10, xlab="")OutputIf ... Read More

When we create a correlation plot using corrplot the correlation among variables is displayed on the plot, if we want to disable some of those correlations then we first need to set them to NA in the correlation matrix and then use the corrplot function with na.label set to blank as " ".Check out the below given example to understand how it works.ExampleFollowing snippet creates a sample data frame −x

To create bar plot with positive and negative values, we can make use of ggplot function.For example, if we have a data frame called df that contains a categorical column say C and a numerical column Num which has some positive and some negative values then the bar plot for this data can be created by using the below command −ggplot(df,aes(C,Num))+geom_bar(stat="identity")ExampleFollowing snippet creates a sample data frame −Category