KnowledgeBoat Logo
|

Informatics Practices

Write a program that performs count, sum, max, and min functions :

  • On rows

  • On columns

Python Pandas

1 Like

Answer

import pandas as pd
data = {
    'A': [1, 2, 3],
    'B': [4, 5, 6],
    'C': [7, 8, 9]
}

df = pd.DataFrame(data)
print("Operations on rows:")
print("Count:")
print(df.count(axis=1))
print("Sum:")
print(df.sum(axis=1))
print("Max:")
print(df.max(axis=1))
print("Min:")
print(df.min(axis=1))

print("\nOperations on columns:")
print("Count:")
print(df.count())
print("Sum:")
print(df.sum())
print("Max:")
print(df.max())
print("Min:")
print(df.min())

Output

Operations on rows:
Count:
0    3
1    3
2    3
dtype: int64
Sum:
0    12
1    15
2    18
dtype: int64
Max:
0    7
1    8
2    9
dtype: int64
Min:
0    1
1    2
2    3
dtype: int64

Operations on columns:
Count:
A    3
B    3
C    3
dtype: int64
Sum:
A     6
B    15
C    24
dtype: int64
Max:
A    3
B    6
C    9
dtype: int64
Min:
A    1
B    4
C    7
dtype: int64

Answered By

2 Likes

Related Questions