Obtaining Dataframe Values

cereal.loc[[63]]

	name	mfr	type	calories	...	shelf	weight	cups	rating
63	Shredded Wheat	N	Cold	80	...	1	0.83	1.0	68.235885

1 rows × 16 columns

cereal.loc[63, 'calories']

np.int64(80)

At this point of the module, we now know how to get a subset of an existing dataframe, but what if we just want to get a single value from it?

For example, what if we wanted to save the calorie content of Shredded Wheat by extracting it from the dataframe manually instead of typing the number in Python?

To do this we use again our .loc notation and we specify the row we are targeting which is 63, followed by the column, here calories. This goes in the square brackets.

When we do this, it displays the the value contained in the cell, which in this case, is 80.

cereal.loc[[66]]

	name	mfr	type	calories	...	shelf	weight	cups	rating
66	Smacks	K	Cold	110	...	2	1.0	0.75	31.230054

1 rows × 16 columns

cereal.loc[66, 'rating']

np.float64(31.230054)

What about if we want the rating of Smacks which is located at index 66?

Again we use .loc[] notation, and we specify the row and the column location separated by a comma.

So here we write cereal.loc and the inside the brackets we write [66, 'rating'].

Let’s apply what we learned!