python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - data-wrangling

What are the differences between ADF Power Query and Power BI Power Query? When would you use one over the other?

I have worked with Power Query in Power BI before and I know that you can wrangle data using Power Query in Data Factory, but why would you want to use one over the other? Are there any functional dif...
test-img

WedgeBuster53

azure

powerbi

etl

azure-data-factory

data-wrangling

Votes: 0

Answers: 1

Latest Answer

why would you want to use the Data Factory version instead of the Power BI version Power Query in ADF is translated to Spark and run on on-demand Spark clusters, so it's potentially much more scalab...
test-img

David Browne - Microsoft

How to sort data in descending order based on every second value in R?

I am using dplyr for most of my data wrangling in R. Yet, I am having a hard time achieving this particular effect. Can't also seem to find the answer by googling either. Assume I have data like this ...
test-img

bajun65537

r

dplyr

tidyverse

tidyr

data-wrangling

Votes: 0

Answers: 2

Latest Answer

One approach using a join: df %>% filter(year == 2021) %>% # group_by(person) %>% slice(2) %>% ungroup() %>% #each person's yr2 arrange(-cash) %>% select(-cash, -year) %>...
test-img

Jon Spring

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 <- "...
test-img

lerm16

r

excel

data-wrangling

wrangle

Votes: 0

Answers: 0

General a column from row-wise totals in R

I have a table that looks like this: df <- tribble( ~name, ~point, ~time, "A", 1, 1, "B", 1, 1, "W", 2, 1, "A", 3, 2, "B", 1, 2, &quo...
test-img

rulesforpower

r

data-wrangling

Votes: 0

Answers: 1

Latest Answer

You can do this: df %>% group_by(time) %>% mutate(W_point_time = point[name == "W"]) # A tibble: 6 x 4 # Groups: time [2] name point time W_point_time <chr> <db...
test-img

Ma&#235;l

Posts

Questions

Blogs

Jobs