# How can I transpose a high dimensional dataset?

I have a (.csv) file with more than 35,000 rows and 100 columns, where the rows represent the attributes and columns represent the instances. In Excel the maximum number of columns is 16,384. Therefore, it is impossible to do this in one single Excel sheet. I need my dataset to be transposed in order to perform some machine learning algorithms in WEKA. Is there any tool allow such thing like this?

Also, is there a way to transpose (.arff) file in WEKA?

This is possible to do in WEKA, but it only works if:

• the first column of your data is of string or nominal type, and
• the rest of your columns are numeric.

Open the dataset in the explorer, and first remove the class attribute by choosing 'No Class' from the drop-down menu on the right. Then, apply the filter from filters.unsupervised.attribute.Transpose. After this, you should re-apply the class attribute by re-selecting the class attribute in the drop-down menu.

If your data doesn't meet the requirements listed above, I would recommend using this short python script to do it:

import pandas as pd