Trending questions in Data Analytics

0 votes
1 answer

How to connect to mysql database from rstudio?

Connect to the database as below. install.packages("odbc") db = ...READ MORE

Oct 7, 2019 in Data Analytics by anonymous
• 33,050 points
4,361 views
0 votes
1 answer

How to add special characters to a list?

@ch, You can add $. , / using ...READ MORE

Oct 14, 2019 in Data Analytics by anonymous
• 33,050 points
3,823 views
+2 votes
1 answer

Why data cleaning plays a vital role in the analysis?

Data cleaning is the fourth step in ...READ MORE

Nov 22, 2019 in Data Analytics by Keshav
2,015 views
0 votes
1 answer

How to create a new table in database from R?

Use dbGetQuery to create a table by ...READ MORE

Oct 14, 2019 in Data Analytics by Cherukuri
• 33,050 points
4,107 views
0 votes
1 answer

Error with rbind

Hey, rbind needs the number of columns ...READ MORE

Oct 14, 2019 in Data Analytics by anonymous
• 33,050 points
3,832 views
0 votes
1 answer

Create train and test data from dataset in R

Hi, Use sample or sample.split function to create ...READ MORE

Oct 14, 2019 in Data Analytics by anonymous
• 33,050 points
3,915 views
0 votes
1 answer

Convert character column to Date field in R Data frame

This is a good question. READ MORE

May 4, 2020 in Data Analytics by anonymous
1,477 views
0 votes
1 answer

Setting up checkpoint dir: PySpark Data Science

You can follow the below steps: Change the ...READ MORE

Aug 2, 2019 in Data Analytics by Zulaikha
• 910 points
6,722 views
0 votes
1 answer

Convert data.frame object into character vector/list

Hi, it is possible to store them ...READ MORE

Jul 9, 2019 in Data Analytics by anonymous
• 33,050 points
7,716 views
0 votes
1 answer

Error with apriori function.

Hey, you forgot to mention support, confidence ...READ MORE

Oct 14, 2019 in Data Analytics by payal
3,648 views
0 votes
1 answer

How to convert a continuous variable to discrete variable and vice versa in R?

Discretize function convert a continuous variable into ...READ MORE

Nov 4, 2019 in Data Analytics by rajeev
4,811 views
0 votes
1 answer

How do I remove an element from a list by index in R?

Use list[index] = NULL The list value will ...READ MORE

Oct 31, 2019 in Data Analytics by Cherukuri
• 33,050 points
2,993 views
0 votes
1 answer

How to import and clean a text file into dataframe in R?

You can use readLines() or read.table() depending ...READ MORE

Jul 16, 2019 in Data Analytics by anonymous
7,293 views
0 votes
1 answer

Difference between [[1]] and [1] in R Programming

Hey Latha, The difference between them is that ...READ MORE

Jun 29, 2019 in Data Analytics by anonymous
• 33,050 points
7,850 views
0 votes
1 answer

How to use add_tally() and add_count()

Hey, add_tally and add_count returns the count of ...READ MORE

Sep 10, 2019 in Data Analytics by Cherukuri
• 33,050 points
5,490 views
0 votes
1 answer

How to add only label or popup withpout markers in a map?

Hi, @ch Use addLabelOnlyMarkers( ) to add labels ...READ MORE

Sep 23, 2019 in Data Analytics by anonymous
• 3,450 points
3,880 views
0 votes
1 answer

How to add layers in ggplot?

You can add multiple layers with one ...READ MORE

Oct 31, 2019 in Data Analytics by Cherukuri
• 33,050 points
2,296 views
0 votes
1 answer

Add a index/Row number column to dataframe

Hi, Bharath. You can add index using seq(1:nrow(data frame)). Example ...READ MORE

Sep 10, 2019 in Data Analytics by Cherukuri
• 33,050 points
5,170 views
0 votes
1 answer

How to make points transparent using plot function in R?

There is no attribute to set the ...READ MORE

Oct 14, 2019 in Data Analytics by Cherukuri
• 33,050 points
2,907 views
0 votes
1 answer

Add image background to ggplot

I found this way from a blog. Check ...READ MORE

Oct 31, 2019 in Data Analytics by Cherukuri
• 33,050 points
2,196 views
0 votes
1 answer

List all dataframes in R session.

Try this. for(x in ls()){   if("data.frame" %in% ...READ MORE

Nov 4, 2019 in Data Analytics by anonymous
• 33,050 points
4,069 views
0 votes
1 answer

How to add leading zeros in R?

There are several solutions to this. One of ...READ MORE

Apr 30, 2018 in Data Analytics by Sahiti
• 6,370 points
25,821 views
0 votes
2 answers

How to remove rows with missing values (NAs) in a data frame?

Hi, The below code returns rows without ...READ MORE

Aug 20, 2019 in Data Analytics by anonymous
• 33,050 points
15,835 views
0 votes
1 answer

How to put border for all legends together and separate borders for each legend in ggplot?

Hi Anitha, There are 2 functions used to ...READ MORE

Jul 24, 2019 in Data Analytics by Cherukuri
• 33,050 points
6,372 views
0 votes
1 answer

Error: `width` is shorter than `ellipsis`FALSE

Add ellipsis = "" attribute to remove ...READ MORE

Oct 29, 2019 in Data Analytics by Cherukuri
• 33,050 points
1,990 views
0 votes
2 answers

Top N and Last N records in R Data Frame

Hi, top_n( ) and top_frac( ) also is ...READ MORE

Sep 3, 2019 in Data Analytics by anonymous
• 33,050 points
5,727 views
0 votes
2 answers

How to set working directory to source file location in R?

Hi,  I'm not sure about the command but you ...READ MORE

Aug 20, 2019 in Data Analytics by Cherukuri
• 33,050 points
15,177 views
0 votes
1 answer

Convert a contingency table into dataframe

The simplest way to convert the contingency ...READ MORE

Oct 21, 2019 in Data Analytics by Cherukuri
• 33,050 points
2,267 views
0 votes
1 answer

Error: object 'params' not found.

@pragyat, Remove " " around data value in ...READ MORE

Nov 4, 2019 in Data Analytics by priya
3,733 views
0 votes
1 answer

what is a contingency table?

A contingency table is a table showing ...READ MORE

Oct 21, 2019 in Data Analytics by Cherukuri
• 33,050 points
2,193 views
0 votes
1 answer

Remove characters from field in dataframe

Use the below code to update the ...READ MORE

Oct 14, 2019 in Data Analytics by anonymous
• 33,050 points
2,447 views
0 votes
1 answer

How to arrange ggplots in custom order?

You can arrange a ggplot by using ...READ MORE

Oct 29, 2019 in Data Analytics by Cherukuri
• 33,050 points
1,795 views
0 votes
1 answer

Error: package or namespace load failed for ‘ggplot2’ - R

Radha, Try restarting the session. the same ...READ MORE

Aug 30, 2019 in Data Analytics by anonymous
• 33,050 points
4,398 views
0 votes
1 answer

Waterfall chart using plotly in R

A simple waterfall chart using plotly - df ...READ MORE

Nov 2, 2019 in Data Analytics by Cherukuri
• 33,050 points
3,678 views
0 votes
1 answer

Show SQL equivalent code of dplyr code in R

show_query() translated dplyr code into sql equivalent ...READ MORE

Oct 14, 2019 in Data Analytics by Cherukuri
• 33,050 points
2,740 views
0 votes
1 answer

Filter with nested if condition in R

Hi Raksha, Use the filter function to filter ...READ MORE

Oct 14, 2019 in Data Analytics by anonymous
• 33,050 points
3,374 views
0 votes
1 answer

Reverse a string in R

Install stringi package and use stri_reverse(). > install.packages("stringi") > ...READ MORE

Oct 14, 2019 in Data Analytics by Cherukuri
• 33,050 points
2,273 views
0 votes
1 answer

Difference between label and popup in addmarkers() in leaflet

Hey, its quite simple. Label in leaflet displays ...READ MORE

Sep 20, 2019 in Data Analytics by rajitha
3,201 views
+1 vote
1 answer

map data not yet available

It could be due to the limited ...READ MORE

Oct 15, 2019 in Data Analytics by anonymous
• 33,050 points
2,603 views
+1 vote
1 answer

How to setup any database connection in R?

Here is how you set up a ...READ MORE

Oct 14, 2019 in Data Analytics by anonymous
• 33,050 points
2,452 views
0 votes
1 answer

How to add labels on bars in bar chart in ggplot?

Use geom_text() to add labels on the ...READ MORE

Aug 20, 2019 in Data Analytics by anonymous
• 33,050 points
4,540 views
0 votes
1 answer

Differences between html_nodes( ) and html_node( )?

Pallava, both the functions return nodes from ...READ MORE

Sep 17, 2019 in Data Analytics by rajeev
3,151 views
0 votes
2 answers

How to use group by for multiple columns in dplyr, using string vector input in R?

data = data.frame(   zzz11def = sample(LETTERS[1:3], 100, replace=TRUE),   zbc123qws1 ...READ MORE

Aug 6, 2019 in Data Analytics by anonymous
15,313 views
0 votes
1 answer

Check if a website permits web scraping - R

Vinutha, While doing web scraping its necessary ...READ MORE

Sep 17, 2019 in Data Analytics by aditya
3,075 views
0 votes
1 answer

Error "Object Concentration not found"

Hi Sanju, is the abc data frame created in ...READ MORE

Oct 18, 2019 in Data Analytics by Cherukuri
• 33,050 points
1,730 views
0 votes
1 answer

Create a new string from existing strings in different variables

Its quite simple, Use paste function as ...READ MORE

Oct 31, 2019 in Data Analytics by Cherukuri
• 33,050 points
1,486 views
0 votes
1 answer

How to convert a dataframe into json data?

Hi, kalyan. Use toJSON function from jsonlite package. ...READ MORE

Sep 24, 2019 in Data Analytics by Cherukuri
• 33,050 points
2,911 views
0 votes
1 answer

R Shiny Error: evaluation nested too deeply: infinite recursion / options(expressions=)?

Hi Kalpana, This error is due to ...READ MORE

Aug 21, 2019 in Data Analytics by anonymous
• 33,050 points
4,209 views
0 votes
1 answer

Reduce markers overlapping in maps

Hey, You can either reduce the font size ...READ MORE

Sep 23, 2019 in Data Analytics by anonymous
• 3,450 points
2,736 views
0 votes
1 answer

How to find cumulative total of rows in r?

Calculate intermediate sum and total sum using ...READ MORE

Oct 29, 2019 in Data Analytics by Cherukuri
• 33,050 points
1,455 views