python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - transpose

Table transformation Google Sheets

I'm trying to convert such table: into such table: First table is very big, and is being changed automatically by another user. I'd like to use Google Sheets' query function. Any idea how? Thanks in...
test-img

raduy

if-statement

google-sheets

transpose

flatten

google-query-language

Votes: 0

Answers: 1

Latest Answer

use: =INDEX(QUERY(SPLIT(FLATTEN(B1:D1&"×"&A2:A&"×"&B2:D), "×"), "where Col2 is not null"))
test-img

player0

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

transpose DataFrame to another DataFrame

I need help to create DataFrame like below City Date Count Moscow 03.04.2022 1 Moscow 02.04.2022 4 Moscow 01.04.2022 7 Barcelona 03.04.2022 2 Barcelona 02.04.2022 5 ... from this D...
test-img

user_Dima

python

pandas

dataframe

transpose

Votes: 0

Answers: 1

Latest Answer

You can use melt: df = df.melt(id_vars='City', var_name='Date',value_name='count').sort_values(by='City') sorting is optional output: >>> City Date count 1 Barcelona 03.04....
test-img

eshirvana

Pivot data in Python

I have a sales data which is in a week-wise format as shown below: cw customers 2022_6 2190 2022_7 2148 2022_8 2407 2022_9 3280 2022_10 3915 2022_11 1396 But I want to transpose ...
test-img

tyler

python

pandas

numpy

pivot

transpose

Votes: 0

Answers: 1

Latest Answer

Based on the result dataset t-1, t-2 etc... columns are more like the shifts of the customers column of the original dataset shift period starting from 0. So you can generate the DataFrame like this: ...
test-img

Drach Noi

Posts

Questions

Blogs

Jobs