Stack Overflow
Stack Overflow

Questions tagged [transpose]

Transposition is an operation that applies to matrices wherein the rows and columns are swapped

The transpose of a matrix A is written as A'. The transpose of matrix A is another matrix B in which the element in the ith row and the jth column of A is in the jth row and the ith column of B. For example:

Suppose A = 

[[11, 12, 13],
 [21, 22, 23],
 [31, 32, 33]]

Then, A' = 

[[11, 21, 31],
 [12, 22, 32],
 [13, 23, 33]]

In scientific software for statistical computing and graphics, function t transposes a matrix.

3257 questions
1
vote
2 answers

VB Excel PasteSpecial requiring clipboard content?

I'm having a problem with VB PasteSpecial. This code works perfectly in Excel VB (given that you have selected cells with data) Selection.Copy Range("A1").Select Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _ False,…
dozacinc
  • 193
  • 1
  • 2
  • 5
1
vote
1 answer

Made typo, Python function still works. Why?

I've been learning programming and Python for about a month now using Udacity. For one of the questions we are supposed to write a function that checks if a sudoku list passed in is valid. In the for loop below, I wanted to iterate through row and…
poteto
  • 21
  • 2
0
votes
0 answers

Matrix transpose using lookup tables

I would like to transpose an array of 8 bytes using lookup tables unlike this post which transposes without using a lookup table: Bitwise transpose of 8 bytes Even though the lookup table would be quite huge as the post mentions, I would like to…
shyamsundar2007
  • 139
  • 2
  • 7
0
votes
2 answers

Tedius transpose in Excel

I have a set of data (26250) on one column, but I need them in rows of 175 values, on other words I need transpose them in 150 rows, and I have to do this for at least 10 files. I wondering if there is a Perl script that can do this automatically. …
user1213013
  • 3
  • 1
0
votes
1 answer

Convert Vertical Data to Horizontal Data (Transpose Won't Work)

I have a spreadsheet with the following values: CUST_ID, NAME, PHONE, EMAIL 0000, John Smith, 000-223-4567, test@email.com 0000, Ed Jones, 001-323-4567, test1@email.com 0000, Frank Dill, 002-423-4567, test2@email.com 0001, Rich Pickle, 003-523-4567,…
RS3
  • 194
  • 1
  • 3
  • 15
0
votes
1 answer

Transpose Datagrid in Flex

I would like to have a datagrid that is transposed in flex. I believe I can do this with an OLAP datagrid but this seems a bit heavy weight. I just want a standard datagrid with a different orientation. For example a datagrid looks…
RNJ
  • 15,272
  • 18
  • 86
  • 131
0
votes
4 answers

How should I transpose a .NET program?

Would it be better to transpose a Microsoft .NET program to standalone by modifying the existing code, or to just use the existing code as a reference? By standalone, I mean that the .NET framework (nor any other) would not have to be installed on…
waiwai933
  • 14,133
  • 21
  • 62
  • 86
0
votes
2 answers

Cocos2D - Efficient Sprite Sheets with Transposed Sprites

I have just started using sprite sheets in Cocos2D in an attempted to better utilize the texture memory and the artist generating my assets has a script that he used for some previous games in Unity3D. The tool takes a number of images, removes the…
CuddleBunny
  • 1,941
  • 2
  • 23
  • 45
0
votes
2 answers

Pivoting a large data file

I have some large tab delimited data files.These files will have a few orders of magnitude more rows than columns. The problem is that I'd like to pivot these files, but in this case "large" is being defined as being too big to do this in memory. I…
geoffjentry
  • 4,674
  • 3
  • 31
  • 37
0
votes
1 answer

Transpose query creates nodes (SQL Server 2008)

I finally found the query to execute to get all ids (comma separated) for one content in one row. Following query did the trick: You don't need to look at the query because it already does what it should do. SELECT taxonomy_item_id, …
Ozkan
  • 2,011
  • 6
  • 29
  • 43
0
votes
2 answers

transpose query varchar bigint conversion

I have the following sql query (this is a transpose query to get comma separated table) SELECT CAST ((SELECT taxonomy_id + ',' FROM content FOR XML PATH('')) AS bigint) AS NewTaxonomytableName But I am…
Ozkan
  • 2,011
  • 6
  • 29
  • 43
0
votes
1 answer

How to join two collection and transpose a collection as an entity using LINQ (c#)

I have the following classes: public class Student { public string StudentID { get; set; } public string StudentName { get; set; } } public class Marks { public string StudentID { get; set; } public string SubjectName { get; set; } …
DhyanaRam
  • 23
  • 4
0
votes
2 answers

How to resolve this general Matlab matrix trick

Just a general Matlab matrix trick I am trying to understand? What does this line really mean logically? S=X*X'; What does S accomplish if I transpose any generic matrix against itself? Thanks
heavy rocker dude
  • 2,271
  • 8
  • 33
  • 47
0
votes
2 answers

Fastest 8x16 bit matrix transpose on MIPS?

I have an 8x16 matrix of bits as a UINT8 matrix[16]. I want to transpose the matrix and store it as a UINT16 matrix2[8]. This is in a time critical piece of my code, and so I need to do this as fast as possible. Is there a clever way to achieve this…
Rocketmagnet
  • 5,656
  • 8
  • 36
  • 47
0
votes
1 answer

calling row data from successive months in successive yrs and writing it into columns?

I have spread sheets of climate data for which, essentially, I need to transpose parts of rows into columns and vice versa. Unfortunately, the format is somewhat awkward. The data came to me with columns for year, month, number of days in the month,…
hdevs
  • 63
  • 1
  • 1
  • 4
1 2 3
…
99
100