current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I have an array:

[['a','1'.'2','3','4'],['b','5','6','7','8'],['c','9','10','11','12'],['d','13','14','15','16']]

I want to subset this and transpose. For transpose it i tried zip function but it outputs array which when i write into a csv file doesn't have the format as tab delimited.

output desired:

a   b
1   5
2   6
3   7
4   8
c   d
9   13
10   14
11   15
12   16

Since i am not able to make tab here i am leaving three spaces in the output.

share|improve this question
    
It's not clear what you want to do to your data structure. The term "subset" has no connection to what you're doing; I don't think it means what you think it means. –  user2357112 Jul 14 '13 at 0:28
1  
Try : zip(array[0],array[1]) and zip(array[1],array[2]). –  Ashwini Chaudhary Jul 14 '13 at 0:34
    
@AshwiniChaudhary The result is a tuple. Can i get it as a matrix as well?? –  Vignesh Jul 14 '13 at 0:43
1  
@Vignesh ideone.com/BX9NAo –  Ashwini Chaudhary Jul 14 '13 at 2:09

1 Answer 1

up vote 1 down vote accepted

This gives the output that looks like what you are looking for:

import numpy as np

a = np.array([['a','1','2','3','4'],
              ['b','5','6','7','8'],
              ['c','9','10','11','12'],
              ['d','13','14','15','16']])

new_a = np.hstack((a[:2,], a[2:])).T

Result:

>>> new_a
array([['a', 'b'],
       ['1', '5'],
       ['2', '6'],
       ['3', '7'],
       ['4', '8'],
       ['c', 'd'],
       ['9', '13'],
       ['10', '14'],
       ['11', '15'],
       ['12', '16']], 
      dtype='|S2')
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.