python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - pivot-table

How to get existing pivot table names and modify them using xlwings?

I am using xlwings(python3) to automate an excel report, need to find a way to get the names of all the existing pivot tables on a given sheet and then change the source data for it, but can't find an...
test-img

Raul Gomez

python

excel

pivot-table

xlwings

Votes: 0

Answers: 1

Latest Answer

It can be done using xlwings api, Pivot tables are accessed with .api.PivotTables() An example to display name and rename table is below. import xlwings as xw filename = 'pivottables.xlsx' wb = xw...
test-img

moken

Is there a way to use pivot_longer with an output of a shared column

I'm trying to use pivot_longer with the repeated measures data. I'm struggling because they have a shared variable. Basically, my data includes target stimuli and their corresponding responses, also a...
test-img

gv99

r

dplyr

tidyverse

pivot-table

Votes: 0

Answers: 2

Latest Answer

We could use the names_sep argument of pivot_longer from tidyr package: Or if you prefer names_pattern argument: Then the regex could be this way: names_pattern = '(.*)_(.*)' library(dplyr) library(ti...
test-img

TarJae

How can i sql pivot column

I've seen a lot of questions that ask about pivot tables.Even if they don't know that they are asking about pivot tables, ...... What is pivot? How do I pivot? how can i pivot this data? +---------...
test-img

Darshil Sakdecha

sql

sql-server

stored-procedures

pivot-table

Votes: 0

Answers: 1

Latest Answer

This isn't a pivot at all, it's string aggregation. In SQL Server 2017+ or Azure SQL Database: SELECT Attendee, Semester, Subjects = STRING_AGG(Subject, ',') FROM dbo.SomeTableName GROUP BY Attend...
test-img

Aaron Bertrand

How do i pivot or transpose specific columns in a table in R?

I have an income dataset that looks like this. CITY 2014 2015 AA 21 22 BB 21 24 I am trying to find a way to make the dataset look like this. CITY Income Year AA 21 2014 AA 21 ...
test-img

Daya V

r

pivot-table

transpose

Votes: 0

Answers: 2

Latest Answer

Welcome to Stack Overflow Daya! In the future, please try to post a reproducible example. These help respondents better understand and diagnose your issues. You can accomplish what you are after usi...
test-img

Sean McKenzie

Posts

Questions

Blogs

Jobs