Using openpyxl python to print data only from 2010? 1 2 3 4 5 6 7 8

Using openpyxl python to print data only from 2010?

Transcribed Image Text:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 A 4/1/10 IBM 5/1/10 IBM 6/1/10 IBM 7/1/10 IBM 8/1/10 IBM 11/1/10 IBM 12/1/10 IBM 13/1/10 IBM 14/1/10 IBM 15/1/10 IBM 19/1/10 IBM 20/1/10 IBM 21/1/10 IBM 22/1/10 IBM 25/1/10 IBM 26/1/10 IBM 27/1/10 IBM 28/1/10 IBM 29/1/10 IBM 1/2/10 IBM 2/2/10 IBM 3/2/10 IBM 4/2/10 IBM 5/2/10 IBM 8/2/10 IBM 9/2/10 IBM 10/2/10 IBM 11/2/10 IBM 12/2/10 IBM 16/2/10 IBM 17/2/10 IBM 18/2/10 IBM 19/2/10 IBM 22/2/10 IBM 23/2/10 IBM 24/2/10 IBM Google B IBM C D E F G 131.18 132.45 130.85 132.97 6155300 131.68 130.85 130.1 131.85 6841400 130.68 130 129.81 131.49 5605300 129.87 129.55 128.91 130.25 5840600 129.07 130.85 129.05 130.92 4197200 131.06 129.48 128.67 131.06 5730400 129.03 130.51 129 8081500 131.33 131.12 6455400 130.39 130.23 129.16 132.31 129.91 132.71 7111800 130.55 132.03 131.78 131.09 132.89 8494400 131.63 134.14 131.56 134.25 13916200 130.46 131.15 15197500 130.47 130.69 9608600 130.25 128.95 129 125.5 126.12 128.67 128.06 125.37 125.71 128.89 10088600 126.89 5738500 126.33 125.92 125.82 125.75 125.41 126.33 125.04 127.75 7135300 126.96 8719200 127.04 9622200 127.03 123.75 123.05 124.32 122.39 121.9 125 11571200 124.95 7242900 123.23 124.67 122.78 124.79 125.53 123.95 125.81 5899900 125.16 125.66 125.07 126.07 4177100 125.19 123 122.9 125.44 9126900 123.04 123.52 121.83 123.72 8617000 123.15 121.88 121.74 123.22 5718500 122.65 123.21 122.46 124.2 6044500 122.21 123.65 5219100 122.94 122.81 122.58 123.73 124.2 5089000 122.06 121.61 124.05 123.01 124 8017700 124.91 6777300 5827400 128 5525900 125.23 124.11 125.23 125.5 126.33 125.21 126.53 126.13 127.81 126 127.35 127.19 126.87 126.31 126 127.59 126.81 127.3 126.85 126.48 126.46 127.02 Microsoft + 128.06 6303100 127.43 3808100 127.66 4591900 128.27 4782000 H I J 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 A 4/1/10 IBM 5/1/10 IBM 6/1/10 IBM 7/1/10 IBM 8/1/10 IBM 11/1/10 IBM 12/1/10 IBM 13/1/10 IBM 14/1/10 IBM 15/1/10 IBM 19/1/10 IBM 20/1/10 IBM 21/1/10 IBM 22/1/10 IBM 25/1/10 IBM 26/1/10 IBM 27/1/10 IBM 28/1/10 IBM 29/1/10 IBM 1/2/10 IBM 2/2/10 IBM 3/2/10 IBM 4/2/10 IBM 5/2/10 IBM 8/2/10 IBM 9/2/10 IBM 10/2/10 IBM 11/2/10 IBM 12/2/10 IBM 16/2/10 IBM 17/2/10 IBM 18/2/10 IBM 19/2/10 IBM 22/2/10 IBM 23/2/10 IBM 24/2/10 IBM Google B IBM C D E F G 131.18 132.45 130.85 132.97 6155300 131.68 130.85 130.1 131.85 6841400 130.68 130 129.81 131.49 5605300 129.87 129.55 128.91 130.25 5840600 129.07 130.85 129.05 130.92 4197200 131.06 129.48 128.67 131.06 5730400 129.03 130.51 129 8081500 131.33 131.12 6455400 130.39 130.23 129.16 132.31 129.91 132.71 7111800 130.55 132.03 131.78 131.09 132.89 8494400 131.63 134.14 131.56 134.25 13916200 130.46 131.15 15197500 130.47 130.69 9608600 130.25 128.95 129 125.5 126.12 128.67 128.06 125.37 125.71 128.89 10088600 126.89 5738500 126.33 125.92 125.82 125.75 125.41 126.33 125.04 127.75 7135300 126.96 8719200 127.04 9622200 127.03 123.75 123.05 124.32 122.39 121.9 125 11571200 124.95 7242900 123.23 124.67 122.78 124.79 125.53 123.95 125.81 5899900 125.16 125.66 125.07 126.07 4177100 125.19 123 122.9 125.44 9126900 123.04 123.52 121.83 123.72 8617000 123.15 121.88 121.74 123.22 5718500 122.65 123.21 122.46 124.2 6044500 122.21 123.65 5219100 122.94 122.81 122.58 123.73 124.2 5089000 122.06 121.61 124.05 123.01 124 8017700 124.91 6777300 5827400 128 5525900 125.23 124.11 125.23 125.5 126.33 125.21 126.53 126.13 127.81 126 127.35 127.19 126.87 126.31 126 127.59 126.81 127.3 126.85 126.48 126.46 127.02 Microsoft + 128.06 6303100 127.43 3808100 127.66 4591900 128.27 4782000 H I J

Answer rating: 100% (QA)

Assuming you have an Excel file with data in a sheet named Sheet1 and the date data is in column A y... View the full answer