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,277 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,760 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,961 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,041 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,785 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,857 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,404 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,639 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,614 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,747 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,567 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,919 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,201 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,375 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,700 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,823 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,115 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,231 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,841 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,014 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,110 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,729 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,716 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,266 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,917 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,666 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,207 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,682 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,038 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,110 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,393 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,737 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,329 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,690 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,594 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,311 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,227 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,117 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,526 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,401 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,472 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,080 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,016 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,665 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,421 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,847 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,148 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,391 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,656 views
0 votes
1 answer

Display labels within pie chart

See below example- df <- data.frame( name ...READ MORE

Nov 2, 2019 in Data Analytics by Cherukuri
• 33,050 points
2,617 views