1. Learn
    2. /
  2. Courses
    3. /
  3. Intermediate Python for Finance

Exercise

Filtering stock data.

For this exercise you will be filtering Alphabet stock data, once again working with a DataFrame alphabet. The head of the DataFrame looks like this:

close volume open high low
date
2019-08-02 1196.32 1745450 1203.00 1209.500 1190.00
2019-08-01 1211.78 1771271 1217.63 1236.298 1207.00
2019-07-31 1218.20 1997999 1224.87 1234.910 1208.18
2019-07-30 1228.00 1430775 1227.00 1236.910 1225.32
2019-07-29 1241.84 2069127 1242.50 1248.995 1230.20

Instructions 1/3

undefined XP
  • 1
    • Create a mask for all of the rows whose daily high is greater than $500.
    • Create a DataFrame using this mask.
  • 2
    • Create a mask for the volume of 1771271.
    • Create a DataFrame of row(s) with a volume of 1771271.
  • 3
    • Make a mask for all rows where the volume does not equal 1997999.
    • Filter using this mask.