Yellow Cab Chicago has hired your small accounting and consulting firm to help them reduce costs and increase revenues. Like many traditional cab companies, Yellow Cab is feeling significant pressure from ride-hailing companies like Lyft and Uber. You are a recent graduate and new to the firm and are excited to learn you will have a role in this engagement.

Load and Look at the Data

Accompanying the case is a CSV file containing 2,000,000 rows of actual cab data from the City of Chicago. Load the data from the CSV file into a DataFrame using the Pandas package. Look at the columns and their data types. How many rows and columns does the DataFrame have? Do any of the DataFrame columns have null values?

Rocket

Testing Code Cells

Like any kind of real data, there are mistakes and omissions in our table. Let’s start by removing null values from key columns of interest. We will not remove all null values, because that would eliminate too much data. Rather, we will think strategically about what variables (or columns) we really care about, and eliminate any nulls in those columns.

In [7]:
import matplotlib.pyplot as plt

friends = [ 70,  65,  72,  63,  71,  64,  60,  64,  67]
minutes = [175, 170, 205, 120, 220, 130, 105, 145, 190]
labels =  ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i']

plt.scatter(friends, minutes)
plt.show()

But how about NumPy arrays?

In [2]:
import numpy as np

numpy_array = np.random.rand(6, 12)
numpy_array
Out[2]:
array([[0.13962294, 0.87761065, 0.41104851, 0.3473787 , 0.74189422,
        0.0144535 , 0.50861946, 0.68430249, 0.64010613, 0.51074718,
        0.90689542, 0.6949895 ],
       [0.61127365, 0.57578185, 0.66863659, 0.29907296, 0.76391015,
        0.30305216, 0.72693037, 0.30488708, 0.02110544, 0.94547793,
        0.62459415, 0.71154387],
       [0.36310251, 0.23603497, 0.56676969, 0.03785169, 0.78082334,
        0.91100643, 0.37822872, 0.51919898, 0.03114835, 0.3033703 ,
        0.64347917, 0.84627086],
       [0.92119849, 0.88520654, 0.49509965, 0.75188237, 0.48052393,
        0.07112154, 0.49469314, 0.45305839, 0.42103655, 0.71158219,
        0.38927259, 0.73671201],
       [0.95287936, 0.66453244, 0.16784101, 0.58649491, 0.26731373,
        0.03179279, 0.01003879, 0.27241261, 0.13196537, 0.58893952,
        0.51545099, 0.1741409 ],
       [0.76495872, 0.26793728, 0.81012043, 0.42211437, 0.57418331,
        0.2761942 , 0.68348613, 0.50741163, 0.20480163, 0.12502683,
        0.25707839, 0.13642688]])

Alright, let's see how my blog handles syntax highlighting.

In [3]:
# Program to count the number of each vowels

# string of vowels
vowels = 'aeiou'

ip_str = 'Hello, have you tried our tutorial section yet?'

# make it suitable for caseless comparisions
ip_str = ip_str.casefold()

# make a dictionary with each vowel a key and value 0
count = {}.fromkeys(vowels,0)

# count the vowels
for char in ip_str:
   if char in count:
       count[char] += 1

print(count)
{'a': 2, 'e': 5, 'i': 3, 'o': 5, 'u': 3}

Simple table

In [4]:
import seaborn as sns

df_titanic = sns.load_dataset('titanic')
df_titanic.head()
Out[4]:
survived pclass sex age sibsp parch fare embarked class who adult_male deck embark_town alive alone
0 0 3 male 22.0 1 0 7.2500 S Third man True NaN Southampton no False
1 1 1 female 38.0 1 0 71.2833 C First woman False C Cherbourg yes False
2 1 3 female 26.0 0 0 7.9250 S Third woman False NaN Southampton yes True
3 1 1 female 35.0 1 0 53.1000 S First woman False C Southampton yes False
4 0 3 male 35.0 0 0 8.0500 S Third man True NaN Southampton no True
In [5]:
df_iris = sns.load_dataset('iris')
df_iris.head()
Out[5]:
sepal_length sepal_width petal_length petal_width species
0 5.1 3.5 1.4 0.2 setosa
1 4.9 3.0 1.4 0.2 setosa
2 4.7 3.2 1.3 0.2 setosa
3 4.6 3.1 1.5 0.2 setosa
4 5.0 3.6 1.4 0.2 setosa

Brain networks dataset

In [6]:
df_brain_networks = sns.load_dataset('brain_networks')
df_brain_networks
Out[6]:
network 1 1.1 2 2.1 3 3.1 4 4.1 5 ... 16.5 16.6 16.7 17 17.1 17.2 17.3 17.4 17.5 17.6
0 node 1 1 1 1 1 1 1 1 1 ... 3 4 4 1 1 2 2 3 3 4
1 hemi lh rh lh rh lh rh lh rh lh ... rh lh rh lh rh lh rh lh rh lh
2 NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN ... NaN NaN NaN NaN NaN NaN NaN NaN NaN NaN
3 0 56.05574417114258 92.03103637695312 3.391575574874878 38.65968322753906 26.203819274902344 -49.71556854248047 47.4610366821289 26.746612548828125 -35.898860931396484 ... 0.6079040169715881 -70.27054595947266 77.36577606201172 -21.73455047607422 1.0282527208328247 7.7917842864990225 68.90372467041016 -10.520872116088867 120.49046325683594 -39.686431884765625
4 1 55.5472526550293 43.6900749206543 -65.49598693847656 -13.974522590637207 -28.27496337890625 -39.05012893676758 -1.2106596231460571 -19.012897491455078 19.568010330200195 ... 57.49507141113281 -76.39321899414062 127.26136016845705 -13.035799026489258 46.3818244934082 -15.752449989318848 31.00033187866211 -39.607521057128906 24.76401138305664 -36.7710075378418
5 2 60.99776840209961 63.43879318237305 -51.10858154296875 -13.561346054077148 -18.842947006225586 -1.2146592140197754 -65.5758056640625 -85.77742767333984 19.247453689575195 ... 28.31736946105957 9.063977241516113 45.4932632446289 26.0334415435791 34.21220016479492 1.326109766960144 -22.58075714111328 12.985169410705565 -75.02745056152344 6.434262275695801
6 3 18.514867782592773 12.65715789794922 -34.576602935791016 -32.665958404541016 -7.420454025268555 17.119447708129886 -41.80086898803711 -58.61018371582031 32.896915435791016 ... 71.43962860107422 65.84297943115234 -10.69754695892334 55.29746627807617 4.2550063133239755 -2.420143842697144 12.098393440246582 -15.819171905517578 -37.36143112182617 -4.650953769683838
7 4 -2.5273923873901367 -63.10466766357422 -13.8141508102417 -15.83798885345459 -45.21692657470703 3.4835495948791504 -62.61333465576172 -49.07650756835938 18.396759033203125 ... 95.59756469726562 50.96045303344727 -23.19729995727539 43.06756210327149 52.21987533569336 28.23288154602051 -11.71975040435791 5.453648567199707 5.169828414916992 87.80913543701172
8 5 -24.90679168701172 -51.19189453125 -29.86799430847168 -27.840293884277344 -24.45510673522949 47.115760803222656 -48.46282196044922 -35.40941619873047 -15.90056610107422 ... 71.70707702636719 108.20982360839844 -38.98595428466797 56.43561553955078 11.073355674743652 22.7122859954834 -24.315147399902344 11.061019897460938 -51.8962516784668 63.12318420410156
9 6 17.273710250854492 0.5400829315185547 18.649370193481445 -9.105488777160645 -2.1172263622283936 87.95771026611328 -16.89242172241211 -30.35905265808105 31.080501556396484 ... 21.22088050842285 112.86585235595705 -11.026081085205078 43.089622497558594 18.862913131713867 58.88899993896485 -48.4278450012207 -1.9686769247055051 -88.8005599975586 79.81661224365234
10 7 20.712934494018555 10.650232315063477 9.156902313232422 -15.88046646118164 1.9488062858581543 51.9166030883789 -23.10546684265137 -10.48654842376709 46.23005294799805 ... 1.960933208465576 128.10523986816406 -20.091087341308594 70.87296295166016 5.356584548950195 2.4634158611297607 -71.22746276855469 -23.842552185058594 -81.41255187988281 41.046146392822266
11 8 48.215309143066406 46.36944961547852 30.311281204223636 21.030553817749023 -14.135848999023438 13.317878723144533 24.96527099609375 22.77110290527344 16.624685287475586 ... -62.8012809753418 28.770023345947266 16.215826034545902 -2.414806604385376 -25.55682945251465 -27.57175254821777 -8.465719223022461 -61.06431198120117 -17.90193748474121 -19.341840744018555
12 9 2.6325457096099854 33.998897552490234 8.142659187316895 42.57246017456055 0.6441326141357422 9.879409790039062 29.57599449157715 30.350440979003906 4.341113567352295 ... 22.89054107666016 -39.99138259887695 43.338600158691406 -14.89726734161377 39.84832382202149 16.728914260864258 73.40428161621094 -39.64643096923828 53.4371452331543 -5.465956687927246
13 10 25.92596435546875 -15.77474880218506 54.6598129272461 80.34854888916016 27.5369815826416 47.93737411499024 42.101318359375 49.02560043334961 -5.077272891998291 ... 2.0362503528594966 -52.86011505126953 47.74828338623047 -18.635520935058594 43.81966018676758 5.793301105499268 101.11161041259766 -23.737102508544922 21.51426315307617 -10.237661361694336
14 11 -56.42181396484375 -74.31371307373047 -22.430784225463867 22.26899528503418 29.032285690307614 73.26942443847656 24.1014461517334 41.09394836425781 -38.17558288574219 ... 29.31868553161621 11.448577880859375 81.84034729003906 7.765820026397705 29.00666427612305 -0.3207019567489624 16.183874130249027 -30.08856964111328 17.721595764160156 0.3083731234073639
15 12 -20.486719131469727 -18.707275390625 -8.405786514282228 10.911598205566406 6.834341526031494 33.627548217773445 8.79491138458252 6.194620132446289 -16.16900634765625 ... -34.897838592529304 26.06122589111328 58.97200775146485 -11.258546829223633 18.986278533935547 22.82738494873047 20.753314971923828 -15.757208824157715 55.46886825561523 -14.726716995239258
16 13 -29.46601867675781 -38.97297286987305 -44.62336730957031 -15.115206718444824 -12.154547691345215 -7.261044979095459 -8.7900390625 -14.007577896118164 6.017861366271973 ... 54.6150016784668 50.74758911132813 67.93879699707031 6.480776786804199 47.14813613891602 -25.27258491516113 20.93616485595703 -6.511287212371826 -3.7719342708587646 19.261005401611328
17 14 -4.389783859252931 -47.51335906982422 37.16338348388672 -2.465017318725586 1.3093246221542358 -23.85207176208496 -3.335904359817505 -2.8855457305908203 20.038055419921875 ... 26.069581985473636 27.10124397277832 26.14088249206543 -17.397573471069336 -34.13585662841797 -30.77999496459961 19.28981208801269 28.44813346862793 20.78366470336914 -19.764381408691406
18 15 -18.445438385009766 -13.10137939453125 29.97665405273437 23.51808738708496 2.768351793289185 -34.16914749145508 2.9590184688568115 -15.972172737121582 34.930843353271484 ... 10.215787887573242 18.57801055908203 -18.487716674804688 -16.542579650878903 10.109452247619627 -32.360069274902344 -18.660051345825195 37.72230911254883 76.00984191894531 -32.095149993896484
19 16 -4.452083110809326 17.155952453613278 33.558406829833984 34.397972106933594 -5.8633790016174325 9.20853328704834 36.2285041809082 3.92244815826416 -12.001194953918455 ... -6.8290138244628915 -45.72415542602539 -2.129183292388916 -13.229391098022461 -14.15742015838623 -44.64008712768555 -74.51631927490234 38.4715690612793 34.32636260986328 -15.103212356567385
20 17 -39.546295166015625 -18.9571475982666 -7.976241111755371 -3.5310790538787837 -5.77384614944458 9.264918327331543 -7.9751834869384775 34.16439819335937 -25.074262619018555 ... 49.91410827636719 18.618200302124023 81.01895904541016 -10.650134086608887 -3.759000301361084 -48.40174865722656 -11.744622230529785 -13.610374450683596 -46.598594665527344 8.662385940551758
21 18 -46.29113388061523 11.07896327972412 -45.2288703918457 -2.8452823162078857 -6.179867267608643 20.13189125061035 -6.460702896118164 -13.874922752380373 -20.737993240356445 ... 50.55953979492188 15.981891632080078 16.855541229248047 -7.0238380432128915 6.322508811950684 -64.27702331542969 -47.45000839233398 -28.18155670166016 -45.41712951660156 -25.33452224731445
22 19 -5.8993568420410165 4.405511856079102 0.08072810620069504 1.2709002494812012 1.2751381397247314 7.154181957244872 2.149699449539185 3.389193296432495 0.2351524978876114 ... -1.9860302209854128 -7.259636402130128 -0.38199055194854736 -3.605726480484009 -1.004348874092102 -11.259474754333494 -11.210288047790527 -0.2647707462310791 -0.8888618350028992 -8.270848274230957
23 20 0.5604530572891235 35.86621856689453 24.45002746582031 31.679840087890625 16.254497528076172 90.16315460205078 23.97650909423828 61.11900329589844 18.228313446044922 ... -75.3877182006836 -42.02395248413086 -26.623645782470703 -64.92243957519531 -41.34647750854492 -35.3553466796875 -63.07796859741211 35.719600677490234 61.04215621948242 -43.62008666992188
24 21 -19.945114135742188 24.615583419799805 49.79893112182617 30.973711013793945 10.343500137329102 13.126060485839846 25.482967376708984 59.22539901733398 6.926406383514403 ... -145.70118713378906 -134.71194458007812 -61.186607360839844 -41.24131774902344 -61.03372192382813 -19.820507049560547 -29.170568466186523 29.974048614501953 18.97161293029785 -62.36677551269531
25 22 -16.305347442626953 -15.824548721313475 37.72407150268555 47.29110336303711 -3.8057398796081534 -56.30646514892578 40.48880386352539 26.910871505737305 -33.36046600341797 ... -66.73892974853516 -89.87995910644531 7.67858076095581 -13.513766288757324 -56.15841674804688 5.067333698272705 -10.628150939941406 19.18693351745605 -6.230216979980469 16.06695556640625
26 23 -18.826845169067386 -31.08311462402344 -6.768689632415772 -34.910385131835945 6.819852352142334 -77.99185180664062 35.50603103637695 60.706031799316406 -51.35368728637695 ... -34.79644775390625 3.4525041580200195 -2.030367136001587 16.79770278930664 -18.85028839111328 69.77201843261719 67.25997924804689 69.69844818115234 65.95340728759766 63.90472793579102
27 24 -68.35137176513672 -47.32866668701172 -10.660748481750488 -17.210674285888672 15.15765380859375 -85.32388305664062 38.7799072265625 56.21023941040039 -29.358064651489254 ... -16.233642578125 42.333587646484375 -5.401229381561278 28.21004295349121 29.71086311340332 74.16902160644531 44.3922119140625 42.90365219116211 98.58329010009766 70.31960296630861
28 25 -41.239173889160156 -36.231346130371094 8.018160820007324 -29.044681549072266 -2.452333688735962 -74.27732849121094 59.311424255371094 68.12519073486328 -22.416826248168945 ... -64.26968383789061 -33.892608642578125 44.16276550292969 -15.829647064208984 -0.6864064335823059 81.61507415771484 8.831643104553223 9.548491477966307 42.5051383972168 24.76482582092285
29 26 -37.63524627685547 -32.697513580322266 35.461830139160156 -22.198781967163086 5.855731964111327 -79.20588684082031 17.229984283447266 11.434855461120605 -7.219680309295653 ... -29.57370567321777 20.83368682861328 1.29855215549469 -36.71852111816406 -86.5921630859375 1.188725233078003 -36.96644973754883 11.874349594116213 64.60060882568361 -18.100265502929688
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
893 890 -21.066452026367188 -7.7635536193847665 5.813338279724121 26.76672172546387 3.4342775344848637 24.01464653015137 4.192936897277832 -3.0223891735076904 28.607036590576172 ... 10.21304416656494 3.59765100479126 8.743330001831055 -4.60745906829834 9.070480346679688 18.672412872314453 -22.64824104309082 27.71781349182129 -6.036958694458008 12.38413906097412
894 891 4.738698959350586 -0.5314908623695374 -24.33356285095215 12.450525283813475 8.395144462585451 16.778339385986328 17.008886337280273 -2.9725069999694824 1.7375296354293823 ... 17.135028839111328 -19.06627082824707 62.815223693847656 36.14525985717773 27.111587524414066 59.90994262695313 55.17409896850586 30.66946029663086 -3.274266004562378 45.14987182617188
895 892 -15.034314155578613 7.501511096954347 -3.909041166305542 2.961850881576538 20.52032852172852 3.353428363800049 -7.26165246963501 -11.17906665802002 9.290842056274414 ... 66.19148254394531 34.010772705078125 12.752458572387695 14.297341346740724 -18.044431686401367 57.27126693725586 -6.957840919494629 45.56645965576172 24.66576957702637 38.678489685058594
896 893 -2.246748685836792 8.323642730712889 -34.524612426757805 -16.08498764038086 -2.8133103847503658 -9.03964614868164 -22.02476692199707 -7.838760852813722 1.4347015619277954 ... 26.76975250244141 20.910898208618164 35.7825927734375 23.20757102966309 34.48352813720703 45.3906364440918 49.6952018737793 42.13819122314453 54.3408432006836 45.972328186035156
897 894 30.75006866455078 10.525860786437988 -43.919830322265625 -29.72777557373047 -7.2232093811035165 -7.57332706451416 -34.088645935058594 -53.65508651733398 23.73687744140625 ... 84.82339477539062 103.1804656982422 12.90157413482666 9.850296974182127 5.918997764587402 45.51707077026367 54.7216682434082 -16.37376594543457 44.90437316894531 55.34864044189453
898 895 163.61553955078125 152.10836791992188 111.5015640258789 81.2813720703125 -21.596677780151367 -8.815573692321777 -122.9453353881836 20.622352600097656 54.72055053710938 ... 198.3489227294922 -17.887998580932614 -23.07147216796875 -107.4202651977539 -14.33807373046875 -86.70722198486328 -69.97971343994139 -91.82875061035156 41.91866683959961 -55.97402572631836
899 896 24.541934967041016 -29.39680099487305 -77.73673248291016 -36.4934196472168 25.047534942626953 1.863014578819275 -25.42117118835449 -22.71465492248535 0.9320054650306702 ... -30.30781555175781 66.30368041992189 21.55731201171875 79.64826965332031 45.47481155395508 -16.209739685058597 -20.904253005981445 -59.63307571411133 -10.611555099487305 54.75290298461914
900 897 -109.93372344970705 -103.2371826171875 -55.536781311035156 -34.57196044921875 21.071434020996094 11.164051055908203 0.9186344742774964 35.156238555908196 -22.73496437072754 ... 55.76713943481445 25.77947998046875 10.97397232055664 0.05258738994598389 15.6325101852417 6.739817142486572 8.269008636474611 17.562986373901367 10.91049861907959 37.25751876831055
901 898 -108.60720825195312 -104.83584594726562 -41.39167785644531 -42.09318542480469 4.437909126281738 27.70398330688477 45.87434387207031 57.24211883544922 3.3504929542541504 ... 42.187496185302734 7.538312435150146 26.700124740600586 -26.40097045898437 17.309200286865234 27.9939079284668 39.201908111572266 17.394851684570312 36.62514114379883 24.039066314697266
902 899 -112.57616424560548 -98.22883605957031 -4.2198095321655265 -4.817594051361084 43.13471603393555 51.47187423706055 41.88451766967773 57.6939582824707 -23.472246170043945 ... -26.40590858459473 18.843708038330078 -12.127391815185547 -42.61675643920898 -38.47690963745117 18.92630958557129 16.351921081542972 -33.51559829711914 32.176868438720696 -13.801525115966795
903 900 -33.65276336669922 -34.22789764404297 41.866615295410156 13.27739429473877 38.05226516723633 42.05718994140625 4.1118574142456055 6.208509922027588 -6.368996620178223 ... -56.17293167114258 -29.23718452453613 -69.3934326171875 -31.69162368774414 -14.640718460083008 -54.72604370117188 -48.01972579956055 -28.39450263977051 -20.43503761291504 8.768814086914062
904 901 -17.347198486328125 -33.56664657592773 10.76189422607422 -21.48106384277344 42.51205825805664 82.23709106445312 -16.716957092285153 -29.16784477233887 -9.294422149658203 ... -30.086069107055664 -22.976192474365234 -49.63053512573242 -34.41447067260742 -12.53892707824707 -40.71413040161133 -13.854580879211426 -19.47832489013672 -11.91209888458252 -65.17855834960939
905 902 -13.73685359954834 -35.78262710571289 -25.39067268371582 -16.98978614807129 13.66233730316162 92.38108825683594 -16.615076065063473 -0.2797889709472656 -48.1323127746582 ... 0.9220491051673888 -12.326903343200685 -26.59357643127441 -27.84567070007324 3.274773359298706 6.653292655944824 7.183495044708253 -17.736907958984375 -43.02948760986328 -47.07931137084961
906 903 -18.13880920410156 -26.41345977783203 -2.2126357555389404 -3.2352876663208012 6.499053001403809 76.70270538330078 -0.107647143304348 -2.357146739959717 -13.857731819152832 ... 11.023125648498537 -20.151945114135746 -30.260725021362305 -6.321748733520508 -48.64393615722656 10.934123039245604 -55.91989135742188 -24.088096618652344 -52.62427520751953 -24.631933212280273
907 904 5.245887279510498 -1.8388237953186035 15.719843864440918 -5.537140369415283 -2.0175764560699463 43.35007095336914 -9.724325180053713 -39.22465896606445 -6.428833484649657 ... -32.13598251342773 43.36977005004883 -45.44424819946289 -1.4917861223220823 -7.46241569519043 -54.68451690673828 -92.14102172851562 -44.70964050292969 -90.87168884277344 -1.964087963104248
908 905 10.630085945129396 9.432680130004883 17.886751174926758 1.6648597717285156 -11.843624114990234 0.2693421840667725 -25.904653549194336 -14.315072059631348 30.02092170715332 ... -70.64630889892578 -47.74853134155274 -69.59804534912111 -2.0508687496185303 -35.864532470703125 -28.324594497680664 -69.76096343994139 -31.3082275390625 -63.20394897460938 -28.511613845825195
909 906 29.79807281494141 22.308609008789066 28.559345245361328 20.01322364807129 5.771327018737793 -11.430606842041016 -3.9495770931243896 -18.457931518554688 4.564800262451172 ... -67.87416839599611 -11.198385238647461 -83.4988021850586 -34.41916656494141 -39.01279830932617 -38.43551254272461 -39.59196090698242 -44.242637634277344 -88.0523681640625 -30.615346908569336
910 907 40.40620803833008 58.85124206542969 30.66959953308105 42.36270523071289 -6.782393455505371 -23.19040870666504 3.6689276695251465 -26.995155334472656 38.44615936279297 ... -103.9883270263672 -3.197364091873169 -50.0429801940918 -46.79253005981445 -22.18362808227539 -43.72720336914063 -16.439886093139652 -24.64264297485352 -8.494021415710451 -44.89055633544922
911 908 17.079118728637695 31.248470306396484 37.793846130371094 32.68141555786133 22.83873176574707 -15.65917682647705 9.255545616149902 -8.21363353729248 15.138961791992188 ... -69.47942352294922 -28.542299270629886 -32.443851470947266 -3.5590937137603764 -0.9022166728973388 -37.8830680847168 -13.597855567932127 2.222918510437012 -10.451070785522461 -18.259809494018555
912 909 45.54562377929688 34.880847930908196 33.66336441040039 19.18587684631348 -14.80003261566162 -17.494770050048828 8.202558517456055 6.329747200012207 24.96369361877441 ... -75.45576477050781 -78.67131042480469 -20.542776107788086 -23.403888702392575 -20.994184494018555 -46.97014236450195 -29.51149177551269 -18.18597221374512 23.59614562988281 -56.41236114501953
913 910 24.22268867492676 13.78703498840332 15.862537384033205 26.21239280700684 -3.6650569438934326 -9.005104064941406 -4.056671142578125 19.608585357666016 10.068506240844727 ... -16.563032150268555 -27.072593688964844 14.270622253417967 16.037710189819336 7.270398139953612 -18.993709564208984 -5.218644618988037 19.18045997619629 -22.920150756835934 -17.739927291870114
914 911 14.745139122009276 29.62375068664551 22.23067283630371 -8.099920272827147 -9.300721168518066 -27.91854858398437 4.063386917114259 9.754743576049805 -4.148948192596436 ... -26.67317771911621 -14.41712760925293 17.312211990356445 -10.833274841308594 -43.56892013549805 42.25391387939453 27.169958114624023 54.83110046386719 18.033618927001953 -34.490859985351555
915 912 -1.3945177793502808 12.264177322387695 3.6463723182678223 8.279685974121094 -30.659217834472656 -28.61190414428711 8.995128631591797 -17.766597747802734 -28.22970199584961 ... 15.663034439086914 16.951265335083008 14.7614107131958 34.577625274658196 25.714786529541016 -20.585512161254886 -15.280298233032227 51.020362854003906 6.1937761306762695 20.407440185546875
916 913 29.18701934814453 32.22170639038086 -3.308156490325928 7.0921058654785165 -25.375640869140625 -39.99783325195313 -11.543415069580078 -31.014671325683594 -10.03612995147705 ... 31.02863883972168 12.37903881072998 -33.630054473876946 17.55772590637207 15.15140438079834 26.667539596557614 21.06236457824707 40.63289260864258 21.620569229125977 15.403238296508787
917 914 33.90782928466797 22.808692932128906 -11.310943603515625 -20.27000617980957 -32.99240493774414 -27.862253189086914 5.8196210861206055 -9.207027435302734 -12.273040771484375 ... 35.98580551147461 81.14118957519531 27.404747009277344 21.85987091064453 -16.414276123046875 53.24932861328125 37.4897575378418 51.77793884277344 31.354591369628906 39.17732620239258
918 915 -7.4295125007629395 -4.81321907043457 -3.670536518096924 1.4422610998153689 -19.6804313659668 -29.109355926513672 -3.3765623569488525 -8.764892578125 0.017911728471517563 ... 58.28579330444336 68.55741119384766 22.83304786682129 76.17948913574219 51.9346694946289 -6.614512920379639 -6.690762042999268 22.893030166625977 48.27437973022461 76.22845458984375
919 916 -33.55413818359375 -38.60562133789063 -25.66480255126953 -30.252351760864254 5.5627851486206055 20.182186126708984 17.91124725341797 24.65358161926269 -32.93561172485352 ... 59.86481857299805 23.00457763671875 7.6574625968933105 50.96239852905274 13.696922302246096 63.50361633300781 57.40117645263672 24.97454833984375 51.97215270996094 64.53878784179689
920 917 -78.53956604003906 -74.19718933105469 -54.04159545898438 -39.97029113769531 -14.277058601379395 -30.606460571289066 60.62852096557617 62.02702331542969 -32.80055618286133 ... 68.76786804199219 49.66401672363281 64.55149841308594 43.80074691772461 8.144479751586914 47.28145980834961 70.49964904785156 66.99440002441406 81.53924560546875 64.96977233886719
921 918 -103.23582458496094 -98.7442855834961 -40.10954284667969 -44.90773391723633 12.109148025512695 1.6213401556015017 33.765560150146484 55.35607147216797 -14.330512046813965 ... 103.1552505493164 106.45484924316406 9.04682731628418 46.67441940307617 40.95479583740234 0.8771800398826599 37.57715225219727 20.517745971679688 3.124434232711792 56.71838760375977
922 919 -36.28886795043945 -10.762069702148438 -30.35626220703125 -23.31950378417969 14.252187728881836 -27.55986022949219 17.279512405395508 -19.060152053833008 26.55877685546875 ... 102.0863037109375 80.05113983154297 -2.6426103115081787 -12.229619979858398 -6.596726417541504 17.665163040161133 16.153173446655273 8.300398826599121 33.687530517578125 17.960655212402344

923 rows × 63 columns

Other elements in Jupyter notebook

  • I recommend you download and install the Anaconda distribution of Python. This is a premiere distribution of Python that is designed for data science. It includes a Jupyter notebook server and JupyterLab.
  • If you want to work on the cloud, you can try Microsoft Azure Notebooks. This is a free service from Microsoft that you can use to study the following:
    • Statistics
    • Calculus
    • Data Analytics
  • First, light the candle.
  • Next, open the box.
  • Finally, place the three magic items in the box, in this exact order, to complete the spell:
    1. The book of spells
    2. The shiny rod
    3. The goblin statue