Stack Overflow
Stack Overflow

Questions tagged [data-management]

312 questions
0
votes
1 answer

Removing multiple columns in R

I have a dataset with about 2,384 variables but only need to use about 39 of them. I have tried to remove the columns that I am working with into another dataset but I keep getting undefined columns selected error message. Below is the code I…
Mark BornSuccessful Harris
  • 15
  • 3
0
votes
3 answers

PHP Data Mapping

I got some data set and it must be mapped, grouping duplicates, like this: I have: "Alfred", "Number" => 1), array("Name" => "Alfred", "Number" => 2), array("Name" => "Alfred", "Number" => 3), …
Valentoni
  • 308
  • 4
  • 19
0
votes
2 answers

cleanly generate and replace values based on a condition

I'm trying to do something very simple in R but I can't get it right. Let's take the "diamonds" dataset from ggplot 2 glimpse(diamonds) $ carat 0.23, 0.21, 0.23, 0.29, 0.31, 0.24, 0.24, 0.26, 0.22, 0.23, 0.30, 0.23, 0.22, 0.31, 0.20, 0.32,…
Antoine Jardin
  • 3
  • 2
0
votes
1 answer

What is the different between an Analytic Platform and Business Intelligence?

Business Intelligence is defined by Gartner as follows: Business intelligence (BI) platforms enable enterprises to build BI applications by providing capabilities in three categories: analysis, such as online analytical processing (OLAP);…
Severin
  • 46
  • 11
0
votes
2 answers

Reshape long to wide where most columns have multiple values

I have data as below: IDnum zipcode City County State 10011 36006 Billingsley Autauga AL 10011 36022 Deatsville Autauga AL 10011 36051 Marbury Autauga AL 10011 36051 Prattville Autauga …
Adam_S
  • 687
  • 2
  • 12
  • 24
0
votes
1 answer

Sort lines based only on its part

Suppose I have a input file that looks like this: 65CH6 N 990 3.717 2.836 2.649 65CH6 HMN1 991 3.807 2.880 2.647 61VAL N 894 4.260 3.037 2.527 61VAL HN 895 4.355 3.063 2.538 61VAL CA 896 4.189 …
user2300369
  • 299
  • 1
  • 3
  • 11
0
votes
2 answers

VB.NET: Properly manage data from XML

Good morning all. I'm relatively new to the Visual Basic realm (although a traditional web based script developer), i've come to ask you a question. I am reading data from an XML file. This local XML file will be updated by another application,…
The Admiral
  • 3
  • 2
0
votes
1 answer

Issue exists in auto generation of number sequence AX

I have been trying to import customer master through data management tool in AX7 using "Customers" standard data entity, I have marked "Auto-Generate" for customer account field. And I am facing a number sequence error while the data gets inserted…
Ashwaq
  • 11
  • 3
0
votes
1 answer

Is there an Admin/Management SDK that works on both Android and iOS?

I have been curious about whether there is a admin SDK that can be implemented in both android and iOS which will help keep tract of metrics and analytics of an app - Similar to Google admin SDK. Or would it make more sense to build an in-house…
David De Backer
  • 3
  • 1
0
votes
2 answers

Sum up observations in Stata

I'm trying to sum up data in Stata. I have UK local authority codes (e.g. E06000047) and a dataset, which is deeper by a level (MSOA). MSOA code MSOA name Local authority code Net weekly income E02004297 County Durham 001 …
arne144
  • 1
  • 1
0
votes
1 answer

How to write a long table in a short summarized table dropping some variables, the values of which are repeated?

First, sorry for the unclear title. But I couldn't think of anything else at this point of time. Suppose i have the data similar to following- Name Type Year ABC ABC-1 2000 ABC ABC-1 2001 ABC ABC-1 2002 ABC ABC-2 …
madmathguy
  • 23
  • 1
  • 7
0
votes
2 answers

How to store a list of objects to memory for later use

I am trying to write a program which will help manage some data. So far, the user can create a new file using a "New File" Dialogue. After the user has entered some parameters, I create a new instance of a "File" class. My questions now is: How can…
Fullk33
  • 230
  • 2
  • 9
0
votes
1 answer

Best way to store company and employee data

I want to create an application where shop owner can register their shop and can store their customer details. My question is what will be the best way to store shop and their corresponding customer information. I can create store and customer table…
Krishna
  • 1,865
  • 4
  • 18
  • 26
0
votes
4 answers

first and last observations in sas

I am trying to flag first and last observations based on baseline date (in my data set it is called baseline_doc) for all same groupings of client_id. For example, I want my final dataset to look like this: Client_id Baseline_Date …
chiccaboomberry
  • 13
  • 4
0
votes
2 answers

Advice on how best to manage this dataset?

New to SAS and would appreciate advice and help on how best to handle this data mangement situation. I have a dataset in which each observation represents a client. Each client has a "description" variable which could include either a comprehensive…
chiccaboomberry
  • 13
  • 4
1 2 3
…
20 21