In [1]:

    

import pandas as pd


    

    




---------------------------------------------------------------------------
KeyboardInterrupt                         Traceback (most recent call last)
<ipython-input-1-af55e7023913> in <module>()
----> 1 import pandas as pd

D:\anaconda\lib\site-packages\pandas\__init__.py in <module>()
     11 for dependency in hard_dependencies:
     12     try:
---> 13         __import__(dependency)
     14     except ImportError as e:
     15         missing_dependencies.append(dependency)

D:\anaconda\lib\site-packages\numpy\__init__.py in <module>()
    140         return loader(*packages, **options)
    141 
--> 142     from . import add_newdocs
    143     __all__ = ['add_newdocs',
    144                'ModuleDeprecationWarning',

D:\anaconda\lib\site-packages\numpy\add_newdocs.py in <module>()
     11 from __future__ import division, absolute_import, print_function
     12 
---> 13 from numpy.lib import add_newdoc
     14 
     15 ###############################################################################

D:\anaconda\lib\site-packages\numpy\lib\__init__.py in <module>()
      6 from numpy.version import version as __version__
      7 
----> 8 from .type_check import *
      9 from .index_tricks import *
     10 from .function_base import *

D:\anaconda\lib\site-packages\numpy\lib\type_check.py in <module>()
      9            'common_type']
     10 
---> 11 import numpy.core.numeric as _nx
     12 from numpy.core.numeric import asarray, asanyarray, array, isnan, \
     13                 obj2sctype, zeros

D:\anaconda\lib\site-packages\numpy\core\__init__.py in <module>()
     12         os.environ[envkey] = '1'
     13         env_added.append(envkey)
---> 14 from . import multiarray
     15 for envkey in env_added:
     16     del os.environ[envkey]

D:\anaconda\lib\importlib\_bootstrap.py in _find_and_load(name, import_)

D:\anaconda\lib\importlib\_bootstrap.py in _find_and_load_unlocked(name, import_)

D:\anaconda\lib\importlib\_bootstrap.py in _load_unlocked(spec)

D:\anaconda\lib\importlib\_bootstrap.py in module_from_spec(spec)

D:\anaconda\lib\importlib\_bootstrap_external.py in create_module(self, spec)

KeyboardInterrupt: 

In [21]:

    

# TODO: Load up the table, and extract the dataset
# out of it. If you're having issues with this, look
# carefully at the sample code provided in the reading
df = pd.read_html('http://www.espn.com/nhl/statistics/player/_/stat/points/sort/points/year/2015/seasontype/2', index_col=0)


    

In [23]:

    

type(df)


    

    
Out[23]:





list

In [ ]:

    

# TODO: Rename the columns so that they are similar to the
# column definitions provided to you on the website.
# Be careful and don't accidentially use any names twice.


    

In [ ]:

    

# TODO: Get rid of any row that has at least 4 NANs in it,
# e.g. that do not contain player points statistics


    

In [ ]:

    

# TODO: At this point, look through your dataset by printing
# it. There probably still are some erroneous rows in there.
# What indexing command(s) can you use to select all rows
# EXCEPT those rows?


    

In [ ]:

    

# TODO: Get rid of the 'RK' column


    

In [ ]:

    

# TODO: Ensure there are no holes in your index by resetting
# it. By the way, don't store the original index


    

In [ ]:

    

# TODO: Check the data type of all columns, and ensure those
# that should be numeric are numeric


    

In [ ]:

    

# TODO: Your dataframe is now ready! Use the appropriate 
# commands to answer the questions on the course lab page.