Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 12384

Questions mostly concerned with managing data, without focus on pre-processing or modelling.

19 votes
Accepted

Do modern R and/or Python libraries make SQL obsolete?

Most, if not all, modern database servers permit multiple users to query data from the same data source and insert, update and delete data in the same tables all while ensuring that the data remains consistent … So, if your computer stops working halfway in a big operation, your data will not be stored. You are also the only person who can access the data. …
Stereo's user avatar
  • 1,423
3 votes
Accepted

How to generate bulk graphics using R

kpi_data) { png(paste0(fn, ".png")) # Plot code dev.off() } You can call the function either as follows, save_KPI_plot("kpi_1", kpi_1_data) or store your file names in one list and your data
Stereo's user avatar
  • 1,423
1 vote
Accepted

Data frame mutation in R

The fastest way would be, require(data.table) data <- data.table(data) # Remove the percentage from your file and convert the field to numeric. data[, Profit := as.numeric(gsub("%", "", Profit))] data … 14:55:00 23.95 ## 9: ZEEL 29/6/2012 14:20:00 -4.65 ## 10: ZEEL 29/6/2012 14:30:00 -6.01 ## 11: ZEEL 29/6/2012 14:55:00 -12.23 ## 12: ZEEL 29/6/2012 15:15:00 35.13 # Melt the data
Stereo's user avatar
  • 1,423
1 vote

Finding aggregated information of data

It is a bit hard to solve your problem without data but I tried to give it a go with a how I think the data would be encoded. I used R with data.tables. You can read data.tables with fread(). … (attendance = sum(num_people)), by = list(division, class)] setkey(attandance_by_division, "class") Step 3 # Merge the data set with a datas set that contains the required number # …
Stereo's user avatar
  • 1,423