Stack Overflow
Stack Overflow

Questions tagged [wrangle]

Wrangle is the domain-specific language used to build transformation recipes in Cloud Dataprep.

A Wrangle recipe is a sequence of transforms, which are applied to your dataset in order to produce your results.

  • A transform is a single action applied to your dataset. For most transforms, you can pass one or more parameters to define the context (columns, rows, or conditions) where the transform is applied to your dataset.
  • Within some parameters of a transform, you can specify one or more functions. A function is a computational action performed on one or more columns of data in your dataset.
24 questions
0
votes
1 answer

Data Fusion Wrangle CSV with empty string

CSV File to import "Date","Facility","FacilityNo" "2022-07-27 00:00:00","Goku Nursing and Rehabilitation Center-1078","1078" "2022-07-27 00:00:00","Gohan Health and Rehabilitation Center-43","433" "2022-07-27 00:00:00","Trunks Health and…
Mr. Diaz
  • 11
  • 2
0
votes
0 answers

How to reflect changes made in xlsx files?

I'm trying to wrangle data from a shared excel file in one drive. I have synced one drive to my macbook so I'm easily able to access it in r with a path. I have the following code: my_data <- "Users/B.../Folder/my_file.xlsx" excel_sheets(path =…
lerm16
  • 21
  • 5
0
votes
1 answer

mutate specific columns with tidyverse

quick question: Can somebody tell me how I do the following in the dplyr syntax? p4[,1:5] <- lapply(p4[,1:5] , factor) Col 1 - 5 were characters and I wanted them to be factors. However, with dplyr I didnt get the job done. My guess was: df <- df…
ic23oluk
  • 125
  • 1
  • 9
0
votes
0 answers

Date dataset wrangling to timeline in R

I have complex problem of using dates in dataset. Let me describe the problem and give example. Data is hospital data, where we have information when person got final diagnose (key_date) and data of events when person has been in hospital (date_in,…
jkm
  • 71
  • 6
0
votes
1 answer

Is there an R function that can convert a existing metric into a new logical metric?

I have a dataset derived from Pokemon statistics containing a lot of the numerical and categorical data. My end goal is to create a model or recommendation system that a user can input a list of Pokemon and the model finds similar Pokemon they may…
Keith Sanders
  • 41
  • 3
0
votes
2 answers

How transform all the variables of a data.table of one row to single values

I created DT putting the values in a table: a <- 2 b <- 20 c <- 0.3 DT <- data.table(a, b, c) let's assume that I have only the DT generated. How can from DT generate a, b, c (single values) Thanks and best regards, SH
highbury
  • 107
  • 8
0
votes
1 answer

I want to make tidy data

I want to make spread data based on duplicate data. I want to accumulate column based on overlapping rows. For example, X2 column is repeated 5 times. It looks similar to using spread function in tidyr package, but it's a little different. Could you…
Sang won kim
  • 524
  • 5
  • 21
0
votes
1 answer

In DataPrep, sum a set of many columns or values in an object

I have a DataPrep dataset which contains a series of ~10 columns, each of which indicates whether or not a particular brochure was selected: BRO_AF BRO_SAF BRO_SE ... 1 1 1 1 1 I'd like to…
Adam Hopkinson
  • 28,281
  • 7
  • 65
  • 99
-5
votes
4 answers

Wrangle data in R

I would like to go from the left table to the right table in the image below but can't seem to find the coding logic behind to reach the result using R. Tables Your help is much appreciated !
Charliebr0wn
  • 13
  • 1
1
2