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,944 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,458 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,472 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,606 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,698 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,101 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,520 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,285 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,430 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,207 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,156 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,516 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,817 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,990 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,911 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,470 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,745 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,147 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,790 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,664 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,440 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,578 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,187 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,762 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,885 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,290 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,302 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,093 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,086 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,391 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,947 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,639 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,347 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,987 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,154 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,374 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,101 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,153 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,139 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,734 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,656 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,688 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,503 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
786 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,293 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,050 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,082 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,584 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,097 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,301 views