Top "Data-manipulation" questions

Data manipulation is the process of altering data from a less useful state to a more useful state.

REAL() can only be applied to a 'numeric', not a 'integer'

Though question seems to be duplicate, i'm posting this as non of them gave a solution and relevant to my …

r data-manipulation xgboost
Split Full Name with Format: {Last, First Middle} Comprehensive Cases

My client sent me name data as a Name string which includes the last, first, and middle names in a …

sql sql-server string data-manipulation data-quality
Transpose data by groups in R

I have data in the following structure: x <- read.table(header=T, text=" X Y D S a …

r reshape data-manipulation
Convert string to dict, then access key:values??? How to access data in a <class 'dict'> for Python?

I am having issues accessing data inside a dictionary. Sys: Macbook 2012 Python: Python 3.5.1 :: Continuum Analytics, Inc. I am working with …

python pandas dictionary data-manipulation dask
Transpose only certain columns in data.frame

Here is the data I have: am group v1 v2 v3 v4 1 2015-10-31 A 693 803 700 17% 2 2015-10-31 B 524 859 302 77% 3 2015-10-31 …

r reshape data-manipulation
Flatten a column with value of type list while duplicating the other column's value accordingly in Pandas

Dear power Pandas experts: I'm trying to implement a function to flatten a column of a dataframe which has element …

python pandas dataframe data-manipulation
Javascript JSON data manipulation library

I'm currently working on a project where I'm dealing with a fair amount of JSON data being transmitted backwards and …

javascript json mobile data-manipulation
Reshape data frame from wide to panel with multiple variables and some time invariant

This is a basic problem in data analysis which Stata deals with in one step. Create a wide data frame …

r panel stata reshape data-manipulation
How do you handle the fetchxml result data?

I have avoided working with fetchxml as I have been unsure the best way to handle the result data after …

xml data-structures dynamics-crm data-manipulation fetchxml
Difference between values in consecutive rows for unique ID's

SQL Server 2008 R2. I need to find the difference between consecutive rows based on a common, unique ID. Data: AccountNumber …

sql sql-server data-manipulation