Extract a specific value in dataframe column name and row index

Question

I have a dataframe with the shape of (5, 7). The column and row index are named from 0~6and 0~4 respectively. This dataframe (Matrix) consists of only four values such as 5,7,8 and 9.

However there are 6 seven values 6 eight values 7 nine values and 16 five values.

Can anyone suggest a code that can extract the number sevens (7), values of column and row??

For example, 1st seven (2, 1)-->(column name, row index) 2nd seven (2, 2)

and do this for eights and nines and etc.

import numpy as np
import pandas as pd

arr = np.array([[5,7,7,8,8,9,5],
               [5,5,8,9,8,5,7],
               [5,5,7,9,9,5,5],
               [5,5,5,9,8,7,5],
               [5,9,9,8,7,5,5]])

df = pd.DataFrame(arr)

why 12,50 ? shouln't it be (0,1) for the first 7? Row 0, Column 1? — Andreas
– Andreas, Commented Dec 17, 2021 at 14:42

BENY · Accepted Answer · 2021-12-17 14:43:28Z

2

Use np.where

np.where(arr==7)
Out[64]: 
(array([0, 0, 1, 2, 3, 4], dtype=int64),
 array([1, 2, 6, 2, 5, 4], dtype=int64))

Change to your format with zip

a = np.where(arr==7)
list(zip(a[0],a[1]))
Out[69]: [(0, 1), (0, 2), (1, 6), (2, 2), (3, 5), (4, 4)]

answered Dec 17, 2021 at 14:43

BENY

324k22 gold badges176 silver badges250 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

babak asadolah Over a year ago

Thank you very much it work just perfect. However, can this code be applied to dataframe?? instead of numpy array?

babak asadolah Over a year ago

I mean can we change the code so that instead of number of column and row indexes, their label shows. For example: [(54.22, 30.92), (55.17, 31.22)], which the number is degree that are labels of rows and columns.

ListenSoftware Louise Ai Agent · Accepted Answer · 2021-12-17 18:38:41Z

0

use two loops

arr = np.array([[5,7,7,8,8,9,5],
               [5,5,8,9,8,5,7],
               [5,5,7,9,9,5,5],
               [5,5,5,9,8,7,5],
               [5,9,9,8,7,5,5]])

def find_7(arr):
    for i in range(len(arr)):
        for j in range(len(arr[i])):
            if arr[i][j] == 7:
                print("row={row}, col={col}".format(row=i,col=j))

print(find_7(arr))

output

row=0, col=1
row=0, col=2
row=1, col=6
row=2, col=2
row=3, col=5
row=4, col=4

answered Dec 17, 2021 at 18:38

ListenSoftware Louise Ai Agent

4,3432 gold badges31 silver badges39 bronze badges

Collectives™ on Stack Overflow

Extract a specific value in dataframe column name and row index

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related