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()
- `sum()` aggregates numeric values within each column.
- Setting `numeric__only=True` restricts the operation to numeric columns only.
- Setting `numeric__only=False` includes both numeric and string columns.

Step 2: String Concatenation
The "NAME" column, being of string type, will have its values concatenated when included in `sum()`:
\[\text{Name column} = "MEENAREENATEENASHEENA"\]
Step 3: Numeric Column Aggregations
- 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}}\]