Stack Overflow
Stack Overflow

Questions tagged [data-management]

312 questions
0
votes
1 answer

sum of two timeseries in R

I am a beginner in timeseries, I have two datatables with different dates and i'd like to have one datatable with all the dates and the sum of the quantitative value ( money paied by the company), for example I have : here is the first datatable…
Mouna
  • 1
0
votes
2 answers

How to get rid of a into the key dependency?

Suppose we have a functional dependency from an attribute outside the primary key to an attribute inside the primary key. How can we get rid of this dependency (which I intuitively think it's bad)? Particularly, suppose we have the following…
nbro
  • 15,395
  • 32
  • 113
  • 196
0
votes
0 answers

how to paste an array to rows which contain a certain value in a certain column in R

I would like to paste values of a certain data.frame row to other rows which have a certain attribute of a certain feature, however not a whole row just a couple of values of it. Exactly it looks like: z <- c(NA, NA, 3,4,2,3,5) x <- c(NA, NA,…
KriKox
  • 43
  • 8
0
votes
3 answers

Reading in Data into SAS using 'Where' function

For some reason I'm not being able to read in the data properly. I want to be able to read in a large data set but within only specific dates such as Jan 2004 to FEB 2004. My Code is the following: DATA Work.sales_fact; SET…
Konfu Chicken
  • 127
  • 7
0
votes
0 answers

What's the most secure way to create database views in a data layer environment for many consumers?

We have a database that will eventually become the system of record for the whole (extremely large) organization. There is customer data, sales data, product data, etc. that certain web applications need access to, and certain departments need…
Stan
  • 7
  • 4
0
votes
1 answer

"Data Repository" software solution

I am trying to find a software solution that will allow our group to easily upload datasets (scriptable and or through some UI), tag those datasets, retrieve those datasets, access control for the datasets, search the tags, search the files…
Kevin Vasko
  • 1,561
  • 3
  • 22
  • 45
0
votes
2 answers

How can I organize my data

Let's say I have a list composed of a client number, number of a store, first name, last name and address which in this format: 11, 2, Lisa, Anderson, NewYork 13, 4, John, Smith, Alabama 54, 2, Lucy, Nicholsson, NewYork etc. What is the best way…
Henrique
  • 45
  • 4
0
votes
2 answers

SAS macro to read multiple rawdata files and create multiple SAS dataset for each raw data file

SAS macro to read multiple rawdata files and create multiple SAS dataset for each raw data file Hi there My name is Chandra. I am not very good at SAS macro especially the looping part and resolving &&. etc. Here is my problem statement. Problem…
Chandra
  • 1
0
votes
1 answer

mysql managing historical data

I have a mysql database that contains three pieces of data; time date stamp, temperature and location of sensor. Every day I would like to maintain the data and only keep historical low,high and average temperature in my database from the past. …
silver
  • 1
0
votes
0 answers

Appending files in a folder using R

i am appending 100 files in a folder with a delimiter "|". Below is the code used. I am getting an error whichi am not able to debug, file_list <- list.files() dataset <- ldply(file_list, read.table, header=TRUE, sep="|") ERROR - Error in…
Madhuri Maddipatla
  • 1
  • 1
0
votes
1 answer

Managing Large amounts of Data in Javascript

I'm currently in the process of making an App using Javascroipt and Phonegap that needs to save a Database or something similar localy while offline until it is later synced with an external Database (not the main Problem). So whats the best…
user2741831
  • 2,120
  • 2
  • 22
  • 43
0
votes
1 answer

Subset by Count of Factors

I am working with Uniform Crime Reporting data for Nebraska cities(a generous classification) and have calculated crime rates for the major classifications from 1995 to 2010 in 5 year increments. I would like to plot the rates for crimes across the…
pophealth
  • 11
  • 6
0
votes
2 answers

How to manage large data in java web services

I have a problem my java web service. How can i manage big data (more than 10 GB). I have to send to consumer this data. Please give me some advise.
ILHOMJON
  • 9
  • 2
0
votes
2 answers

how to detect specific value combination (or condition) of variables within group

I have a survey dataset which contains household ids and individual ids within each household: individual 1 represents the interviewee him/herself. Some variable represents each individual's relationship to the interviewee (for example, 2 for…
zlqs1985
  • 509
  • 2
  • 8
  • 25
0
votes
1 answer

Data Mangement and Coding in R

I have two questions. The first is a data management question and the second is the creation of a new variable. My data is structured, but I am not sure what is the correct r code. I am looking at congressional committee data. My unit of…
Dyllan
  • 117
  • 10
1 2 3
…
20 21