Search Results
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 |
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. …
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 …
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 …
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
# …