3,403 questions
0
votes
0
answers
28
views
Mysql rows transposing in Node.js with mysql2 [duplicate]
I am running an SQL script in Node.js using mysql2 npm-package. This script has multiple SQL statements that have to ultimately transpose a table's rows into columns. The SQL script runs correctly ...
- 11
-2
votes
1
answer
144
views
CUDA more load transactions than store even though both are coalesced?
I am profiling the NVIDIA's matrix transpose sample. From the looks of it and from the profiler, there are no bank conflicts. However, one thing I noticed is that global load transactions per request ...
- 27
0
votes
1
answer
93
views
big query data transformation logic
I am trying to get a data in a specified format, currently this is in the form.
I want to write a sql query which would get me the data in this form
I tried with converting it to array and unnest ...
0
votes
1
answer
78
views
SAS use proc transpose to make long race and ethnicity variables wide
I am using 10 years CDC population data to run an analysis by state and year. Within the analysis, I am going to use race and ethnicity data. The issue I am having is figuring out how to use proc ...
- 101
1
vote
1
answer
65
views
Join columns by rows for each time step
my dataframe is as follows and I would like to rearrange, update and save it to csv or similar format.
time lat lon ws wd
1/1/2023 0:00 -5 107 8.214895 313.9049
1/1/2023 0:...
- 25
0
votes
3
answers
98
views
Will transpose help me in this problem? Or is there another function
Hey guys I will post my question as pic to be clear I need solution for this in excel or python
- 45
1
vote
1
answer
523
views
Transpose columns to rows - multiple columns
I have a query output that is formatted like this:
yr_mo
Sales
Transactions
Items
Shipping Cost
Tax
2024-04
20
50
100
12
2
2024-03
10
25
50
6
1
This isn't a great way to view the data, since the data ...
- 11
0
votes
2
answers
47
views
SAS Transpose and summarise data
I have a dataset that looks like this:
Account Number 6m 7m 8m 9m 10m 11m 6m_Metric 7m_metric 8m_metric 9m_metric 10m_metric 11m_metric
1 ...
- 525
0
votes
1
answer
73
views
Find next empty row on separate sheet to transpose data
I need to copy data from one sheet (Saudi) only copying 1 particular column (D) and transpose that data (keeping the values in there) to another sheet (Results) to the next available row.
I have ...
- 1
0
votes
2
answers
152
views
Mean value of a Dataframe comes out transposed
I am iterating over serval files and for each file I get a data frame.
I then calculate mean for each data frame using following.
BinA_Data.mean(axis=0,skipna=True, numeric_only=True))
But the ...
- 81
3
votes
2
answers
61
views
Transposing dataset with repeated / incomplete observations in R
I have the following dataset:
Pt_ID vital_descr vital_value
1 HR 70
1 SBP 110
1 DBP 75
1 HR NA
1 SBP 105
1 DBP 60
2 SBP 150
2 DBP 90
3 HR 55
3 SBP 150
3 DBP 70
3 ...
0
votes
1
answer
80
views
creating hierarchy from rows
the table 'accounts' has values as below:
CREATE TABLE as accounts (
le_parent varchar2(100),
legal_entity varchar2(100),
trans_account_parent varchar2(100) ,
trans_account varchar2(100),
...
0
votes
1
answer
27
views
Transform content of a row into columns in r [duplicate]
I have a dataframe named "Num_casos_Sar" with a structure like that:
Cod_municip Ano Not_Sarampo
1 310110 1989 3
2 310160 1988 0
3 310350 1985 ...
-2
votes
1
answer
109
views
Dynamic column amount from rows in PHP
I have a dataset from which i want to display the unique values in a row from 1 column as columns, and the first column from unique sets from an other row. And then fill the matrix with the values ...
- 3
0
votes
2
answers
56
views
How to properly use pivot_wider() to align the values of two variables?
I have one dataset as below.
library(dplyr)
library(tidyr)
df= tibble::tibble(
variety=rep(c("CV1", "CV2", "CV3"), each=16L),
irrigation=rep(rep(c("yes"...
- 964
1
vote
1
answer
58
views
How Can I Reorganize my Pandas DataFrame so that column names become column values?
I currently have a dataframe that looks like this:
Movie 1
Movie 2
1st choice
2nd choice
2nd choice
1st choice
I would like to have a dataframe that looks like this:
1st Choice
2nd Choice
Movie 1
...
0
votes
2
answers
518
views
Display the text from specific cells of another excel tab into one column - I need an updated version of TAB!CELL
I have an Excel file with the tab "Content" and tab "Review". I want to display/show the text from specific cells from the tab "Content" in a specific column one below ...
- 23
0
votes
1
answer
49
views
Formula needed for column and row dependency
Tried several times with Query formula, but failed so far.
I have a simple source that looks like this, columns of date, product and quantity.
On another sheet I have a table that has the products on ...
- 451
0
votes
1
answer
289
views
Transpose a dataframe inplace into a for loop (python-pandas)
I have a list of dataframes. All the dataframes have 75 columns and variable number of rows (between 18 to 1000). The column names are dates, I will use these dates to plot time series. There are ~50 ...
- 5
0
votes
1
answer
64
views
How to make multiple columns of independent values into 2 column in R
If I have data that looks like this
Condition 1
Condition 2
11
41
17
45
where the numeric values are length.
Is there a way to change the data so that it looks like this instead
Condition
length
...
- 1
0
votes
1
answer
43
views
Partially transpose a table in BigQuery SQL
I have a table that calculates revenues and costs like this :
Project name
revenues
costs
margin
One
3
1
2
Two
10
3
7
Three
6
1
5
And need to transform the columns into additional rows, creating a ...
- 132
0
votes
0
answers
44
views
Issues with dataframe after transposition seemingly not numeric without any obvious reason
I have got this pipeline that works perfectly without transposition but suddenly everything goes wrong once I need to transpose my data.
My data are loaded from an excel file, I have other 29000 ...
- 1
-1
votes
1
answer
45
views
Why does this not work for inverting a 2-D square array? [duplicate]
I'm trying to invert (transpose) a 2-D square array in python. I know there are ways to do this with numpy, but since I have just a square array, I thought it could be simply done with the following:
...
0
votes
1
answer
42
views
Pivot/transpose Query
My current SQL query return response as:
select count(*) as count, appointment_status
, cast(created_time as date) as date
from appointment_master
where created_time >= '2024-01-21'
group by ...
- 179
0
votes
1
answer
101
views
What mathematical or memory trick does numpy.flatten() use on numpy.transform?
I am trying to replicate transpose + flatten method of numpy. In order to take transpose, I only swap the last dimension with the dimension I want to transpose. Then I transform item positions to
...
