Ad

Shuffling Multi Column In Data Frame

i have a Data frame like this :

'a'                   'b'    'c'    'd'               'e'  'f'
'hello.text'           1      2      'hello2.text'     2   10
'hello3.text'          5      8      'hello4.text'     8   15

now i need shuffle or randomize 'a','b','c' columns together. some thing like this :

'a'                   'b'    'c'    'd'               'e'  'f'
'hello3.text'          5      8      'hello2.text'     2   10
'hello.text'           1      2      'hello4.text'     8   15

how can i do this?

Ad

Answer

Use np.random.permutation with DataFrame.apply for processing each column separately, because different types of data:

cols = ['a','b','c']

df[cols] = df[cols].apply(lambda x: np.random.permutation(x))
print (df)
               a  b  c              d  e   f
0   'hello.text'  5  2  'hello2.text'  2  10
1  'hello3.text'  1  8  'hello4.text'  8  15
Ad
source: stackoverflow.com
Ad