Question

Consider the given DataFrame df4:

NAME	PERIODIC	ENG	MATHS	SCIENCE
MEENA	1	40	60	80
REENA	2	60	30	10
TEENA	3	80	60	40
SHEENA	2	90	20	70

We want the following output:

NAME	MEENAREENATEENASHEENA
PERIODIC	8
ENG	270
MATHS	170
SCIENCE	200

• A. print(df4.sum(numeric_only=True))
• B. print(df4.sum(numeric_only=False))
• C. print(df4.sum())
• D. print(df4.count(numeric_only=True))

Hint:

Use \texttt{numeric__only=False} to include string concatenation along with numeric summation in Pandas.

Answer 1

The Correct Option is B

Step 1: Behavior of sum()
- \texttt{sum()} adds up numeric values in each column.
- With \texttt{numeric__only=True}, only numeric columns are included.
- With \texttt{numeric__only=False}, both numeric and string columns are processed.

Step 2: String concatenation
The column "NAME" is of string type. When included in sum(), all names are concatenated:
\[ \text{Name column} = "MEENAREENATEENASHEENA" \]
Step 3: Numeric column sums
- PERIODIC: \(1+2+3+2=8\)
- ENG: \(40+60+80+90=270\)
- MATHS: \(60+30+60+20=170\)
- SCIENCE: \(80+10+40+70=200\)
\[ \boxed{\text{Correct Output obtained only with numeric__only=False}} \]