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
3,938 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,453 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
1,601 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,465 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
3,691 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,097 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,512 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,282 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,420 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,202 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,151 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,508 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
6,805 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
4,979 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
1,899 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,460 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
4,735 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,130 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
1,783 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
3,655 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,431 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,569 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,177 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
5,748 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
1,877 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,283 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,295 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,078 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,080 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,383 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
3,942 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
1,632 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,340 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
2,982 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,145 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
14,358 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,094 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,142 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
1,727 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,127 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
2,648 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
2,680 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,500 views
0 votes
1 answer

Splitting strings in a list delimited by space

Use strspltit function and provide separator as ...READ MORE

Oct 30, 2019 in Data Analytics by Cherukuri
• 33,050 points
778 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,283 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,039 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,077 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
2,573 views
0 votes
0 answers

How to convert a table into tree?

I used getTree() and randomForest object to ...READ MORE

Oct 22, 2019 in Data Analytics by ch
• 3,450 points
1,092 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,293 views