"Let me answer myself in case if some one else face the same issue :)
df <- data_frame(text=junk) df %>% separate_rows(text, sep = '\n') %>% filter(text != "") %>% extract(text, into = c('group'), regex…"
Neeraj Sharma's Discussions
Add column values as new row conditionally
Started this discussion. Last reply by Neeraj Sharma Mar 22. 1 Reply 1 Like
I csv data file in below format:1:1011022:1031041053:106107I want result as below in RValue id101 1102 1103 2104 2105 2106 3107 3I did…Continue
Analysis of survey conducted on grocery store customers
Started Feb 24 0 Replies 0 Likes
I have given a survey conducted on customers of grocery shop. This grocery shop has sensors which keeps track what items i picked and will be billed accordingly on exit of store app.Survey conducts…Continue
Merge row data
Started this discussion. Last reply by Neeraj Sharma Mar 17. 7 Replies 2 Likes
I have four columns in my data set like below:A B C D0 NA NA NA0 NA NA NANA 1 NA NANA 0 NA NANA NA 0 NANA NA 1 NANA …Continue
Gifts Received
Neeraj Sharma has not received any gifts yet
Neeraj Sharma's Page
Latest Activity
Neeraj Sharma posted a discussionAdd column values as new row conditionally
I csv data file in below format:1:1011022:1031041053:106107I want result as below in RValue id101 1102 1103 2104 2105 2106 3107 3I did using for loop but it takes lot of time. Original data 3MB file.Added extra column "m_id" in test_data dataframe and executed below code.f <- function(x){ value = 0 if(endsWith(as.character(x) ,":") == TRUE){ value = substr(x,0,nchar(x)-1) } return (value) }for(row in 1:nrow(test_data)){ id = 0 id =…See More
Neeraj Sharma replied to Neeraj Sharma's discussion Merge row data"Thank you every one for your help. I am able to do achieve this row merge in R as well as in Python. "
Okan OYMAK replied to Neeraj Sharma's discussion Merge row data"Here is how you can do it in R using just a one-line code.
apply(yourData, 1, function(data) { data[which(!is.na(data))] })
You can also type 2 if you wanna do the operation columnwise.
I would be happy to hear if it worked for you."
Neeraj Sharma posted a discussionAnalysis of survey conducted on grocery store customers
I have given a survey conducted on customers of grocery shop. This grocery shop has sensors which keeps track what items i picked and will be billed accordingly on exit of store app.Survey conducts few questions like (everything rated 1-5)Availability of products.Access to different products(whether you are able to search required product easily or not)Ease of parkingEase of billingQuality of productsThis survey has to be analysed statistically and pick out most painful area.I generated a…See More
steve miller replied to Neeraj Sharma's discussion Merge row data"nice answer. you wanna use array operations. numpy's an elegant and efficient library."
Kornel Olszewski replied to Neeraj Sharma's discussion Merge row data"Hi,
I believe a simple solution would be to use foreach loop construct. Let us declare the dataset:
t1 = data_frame( A=c( rep(0,2),rep(NA,6) ) ,B=c( rep(NA,2),1,0,rep(NA,4) ) …"
steve miller replied to Neeraj Sharma's discussion Merge row data"actually, for this exercise, dplyr isn't necessary."
steve miller replied to Neeraj Sharma's discussion Merge row data"I'm a big proponent of using R packages data.table and dplyr (tidyverse) in collaboration:
library(data.table) library(dplyr)
dt <-…"
John Swanson replied to Neeraj Sharma's discussion Merge row data"I think the easiest and quickest way would be to use the Numpy package for Python. It performs operations on arrays very quickly.
You can enter the data into a Numpy array, or use the numpy.asarray() to put your Python list into an array:
x…"
Neeraj Sharma's discussion was featuredMerge row data
I have four columns in my data set like below:A B C D0 NA NA NA0 NA NA NANA 1 NA NANA 0 NA NANA NA 0 NANA NA 1 NANA NA NA 0NA NA NA 1I want to merge all columns in one column and want the output as below:A00100101How we can do this in R and python?See More
Profile Information
- Short Bio
- Working till now on JAVA but very much passionate for data analysis. From last 8 months going through various courses for data science. Trying hard to work full time on data analysis.
- My Web Site Or LinkedIn Profile
- http://https://www.linkedin.com/in/neeraj-sharma-00788ba/
- Field of Expertise
- Analytics
- Professional Status
- Technical
- Years of Experience:
- 10
- Your Company:
- Cisco
- Industry:
- Software
- Your Job Title:
- SE III
- How did you find out about DataScienceCentral?
- via articles posted on Linked In
- Interests:
- Finding a new position, Networking, New venture
- What is your Favorite Data Mining or Analytical Website?
- http://www.datasciencecentral.com/,https://www.r-bloggers.com,https...
- What Other Analytical Website do you Recommend?
- http://https://www.datascienceweekly.org/
Comment Wall
- No comments yet!
Follow Us
Top Content
Announcements
Videos
Resources
© 2018 Data Science Central
Powered by
Badges | Report an Issue | Privacy Policy | Terms of Service
