Write a program in Python to select any random odd index rows in a given DataFrame

Assume, you have a dataframe,

DataFrame is:  id mark age 0 1 70   12 1 2 60   13 2 3 40   12 3 4 50   13 4 5 80   12 5 6 90   13 6 7 60   12

And, the result for selecting any random odd index row is,

Random odd index row is:  id    4 mark   50 age    13

Solution

To solve this, we will follow the steps given below −

• Define a dataframe

• Create an empty list to append odd index values

• Create a for loop to access all the index. It is defined below,

for i in df.index.values:

• Create an if condition to check the odd index. If it is matches, then append the values to the list,

if(i%2==1): l.append(i)

• Generate any one random value from the list and store it random_index

random_index = rand.choice(l)

• Finally, print the odd index row using the iloc.

df.iloc[random_index]

Example

Let’s see the below implementation to get a better understanding −

import pandas as pd import random as rand df = pd.DataFrame({'id': [1,2,3,4,5,6,7],                   'mark': [70,60,40,50,80,90,60],                   'age':[12,13,12,13,12,13,12]                   }) print("DataFrame is:\n",df) l = [] for i in df.index.values:    if(i%2==1):       l.append(i) random_index = rand.choice(l) print("Random odd index row is: \n", df.iloc[random_index])

Output

DataFrame is:  id mark age 0 1 70   12 1 2 60   13 2 3 40   12 3 4 50   13 4 5 80   12 5 6 90   13 6 7 60   12 Random odd index row is:  id    4 mark   50 age    13 Name: 3, dtype: int64