Pandas学习打卡day#1

import pandas as pd
import numpy as np
pd.__version__

'1.0.3'

px = pd.read_csv('F:/data/Game_of_Thrones_Script.csv').head()
px

	Release Date	Season	Episode	Episode Title	Name	Sentence
0	2011/4/17	Season 1	Episode 1	Winter is Coming	waymar royce	What do you expect? They're savages. One lot s...
1	2011/4/17	Season 1	Episode 1	Winter is Coming	will	I've never seen wildlings do a thing like this...
2	2011/4/17	Season 1	Episode 1	Winter is Coming	waymar royce	How close did you get?
3	2011/4/17	Season 1	Episode 1	Winter is Coming	will	Close as any man would.
4	2011/4/17	Season 1	Episode 1	Winter is Coming	gared	We should head back to the wall.

px['Name'].nunique()

3

px['Name'].unique()

array(['waymar royce', 'will', 'gared', 'royce', 'jon snow',
       'septa mordane', 'sansa stark', 'eddard stark', 'robb stark',
       'jonrobb', 'cassel', 'catelyn stark', 'bran stark',
       'theon greyjoy', 'jaime lannister', 'cersei lannister',
       'maester luwin', 'luwin', 'arya stark', 'robert baratheon',
       'tyrion lannister', 'ros', 'viserys', 'daenerys targaryen', 'maid',
       'illyrio', 'benjen', 'a voice', 'jorah mormont', 'khal drogo',
       'sandor clegane', 'doreah', 'irri', 'viserys targaryen',
       'joffrey lannister', 'myrcella baratheon', 'benjen stark',
       'assassin', 'jhiqui', 'rodrick cassel', 'mycah', 'soldier',
       'jory cassel', 'kings landing guard', 'varys', 'renly baratheon',
       'petyr baelish', 'grand maester pycelle', 'old nan', 'guard',
       'alliser thorne', 'jeor mormont', 'grenn', 'pyp', 'rast',
       'barristan selmy', 'lancel lannister', 'rakharo', 'yoren',
       'rhakaro', 'maester aemon', 'syrio forel', 'sam tarly',
       'janos slynt', 'hugh of vale', 'tobho mott', 'gendry baratheon',
       'marillion', 'masha heddle', 'bronn', 'knight of house whent',
       'knight of house bracken', 'loras tyrell', 'rodrik cassel',
       'illyrio mopatis', 'vardis egen', 'steward', 'lysa arryn',
       'robin arryn', 'mord', 'mhaegen', 'osha', 'wildling', 'knight',
       'ser vardis', 'barriston', 'man', 'beric dondarrion', 'mordane',
       'tywin lannister', 'night watch stable boy', 'lord varys',
       'deanerys targarian', 'little bird', 'wine merchant',
       'jaremy rykker', 'othell yarwyck', 'pypar', 'tell me something',
       'tomard', 'king joffrey', 'steward of house stark', 'meryn trant',
       'maryn trant', 'kings guard', 'stable boy', 'ser alliser',
       'nights watch brother', 'shagga', 'kevan lannister', 'messenger',
       'rodrik cassal', 'greatjon umber', 'stark guard',
       'lannister scout', 'kings landing page', 'everyone', 'walder frey',
       'stevron frey', 'ryger rivers', 'voices outside',
       'unidentified nights watchers', 'nights watcher', 'all', 'cohollo',
       'qotho', 'prostitute', 'shae', 'mirri maz duur',
       'lannister soldier', 'tribesmen of vale', 'stark bannermen',
       'kings landing baker', 'street urchin', 'populace', 'eddark stark',
       'rickon stark', 'several stark bannermen', 'jonos bracken',
       'galbart glover', 'rickard karstark', 'leo lefford',
       'addam marbrand', 'sam pyp and grenn', 'hot pie',
       'lommy greenhands', 'announcer', 'ser dontos', 'myrcella',
       'pycelle', 'janos', 'lord', 'portan', 'sam', 'edd', 'lord mormont',
       'craster', 'watchman', 'gilly', 'melisandre', 'group', 'cressen',
       'davos', 'crowd', 'stannis baratheon', 'matthos', 'alton',
       'ser rodrik', 'others at table', 'roz', 'daisy', 'mhaegan',
       'gold cloak', 'blacksmith', 'cold', 'end', 'title', 'jaqen hghar',
       'rorge', 'woman', 'podrick', 'lommy', 'yara greyjoy', 'balon',
       'all three', 'saan', 'jeor', 'hodor', 'margaery tyrell', 'loras',
       'renly', 'brienne', 'colen', 'gerard', 'tommen lannister',
       'priest', 'drowned priest', 'timett', 'rennick', 'men',
       'roose bolton', 'wounded soldier', 'talisa', 'lancel', 'meryn',
       'kovarro', 'mountain', 'tickler', 'prisoner', 'spice king',
       'spice', 'xaro', 'polliver', 'girl', 'protester', 'black lorren',
       'dagmer', 'reginald', 'amory', 'dolorous edd', 'dolorous',
       'haylene', 'pyatt pree', 'quaithe', 'winterfell shepherd',
       'rodrik', 'qhorin', 'farlen', 'ironborn', 'rickon', 'armory',
       'ygritte', 'septon', 'cuard', 'quent', 'roose', 'ahsa', 'rikon',
       'mountian', 'child', 'handmaiden', 'quaith', 'silk king',
       'pyat pree', 'pyattpree', 'jacks', 'rickard', 'mar',
       'lord of bones', 'rider', 'kevan', 'quorin', 'eddision',
       'male singer', 'drogo', 'rattleshirt', 'main', 'boy', 'tormund',
       'mance', 'whore', 'salladhor', 'qyburn', 'missandei',
       'kraznys mo nakloz', 'unsullied', 'barristan', 'jojen', 'torturer',
       'tailor', 'olenna tyrell', 'servant', 'orell', 'meera', 'thoros',
       'anguy', 'ramsay bolton', 'locke', 'edmure', 'brynden', 'driver',
       'martyn', 'karl tanner', 'kraznys', 'greizhen', 'marei', 'beric',
       'willem', 'selyse', 'shireen', 'grey worm', 'olyvar',
       'black walder', 'lothar', 'radzal mo eraz', 'myranda', 'violet',
       'steelshanks walton', 'daario', 'mero', 'prendahl', 'walder',
       'merry', 'pig farmer', 'old man', 'roslin', 'edmure roslin',
       'blackfish', 'everybody', 'frey guard', 'frey man', 'frey men',
       'frey soldier', 'daughter', 'dornish lord', 'oberyn martell',
       'ellaria', 'morgan', 'morgans friend', 'warg', 'styr', 'officer',
       'janos slunt', 'innkeeper', 'tansy', 'walda', 'mace',
       'axell florent', 'threeeyed raven', 'musician', 'renly dwarf',
       'robb dwarf', 'joffrey dwarf', 'balon dwarf', 'stannis dwarf',
       'farmer hamlet', 'ranger', 'moles town whore', 'moles town madam',
       'olly', 'guymon', 'ollys mother', 'yarwyck', 'alliser thorn',
       'mossador', 'elder meereen slave', 'meereen slave', 'slaves',
       'tanner', 'women', 'sissy', 'robin', 'lysa', 'karl',
       'doloroud edd', 'dolrous edd', 'morag', 'tycho', 'sallador',
       'lhara', 'first mate', 'bolton guard', 'manservant', 'hizdahr',
       'pyelle', 'dying man', 'alliser', 'yarwick', 'ed', 'ralf', 'petyr',
       'lord royce', 'lady anya', 'ser vance', 'ser barristan',
       'ser jorah', 'lord bolton', 'together', 'pycell', 'aemon',
       'thenn warg', 'nights watch', 'member', 'donnel', 'cooper',
       'all together', 'fennesz', 'captain', 'melara', 'maggy',
       'white rat', 'master of arms', 'yohn royce', 'squire',
       'grand maester pyrcelle', 'daario naharis', 'hizdahr zo loraq',
       'braavosi man', 'waitress', 'lollys stokeworth', 'lollys',
       'trystane', 'areo', 'doran', 'hunters', 'mace tyrell',
       'shadow tower brother', 'brother', 'brothers', 'harpy', 'mosador',
       'bystanders', 'waif', 'sparrow', 'priestess', 'blonde prostitute',
       'black haired prostitute', 'merchant', 'militant', 'client',
       'kingsguard', 'tyene', 'elaria', 'obara', 'nymeria', 'allister',
       'malko', 'slaver', 'sand snakes', 'derryk', 'sammy', 'slave buyer',
       'buyer', 'buer', 'slave owner', 'owner', 'septa', 'thin man',
       'bolton bannerman', 'master', 'karsi', 'loboda', 'wildling elder',
       'giant', 'wun wun', 'shouting', 'banker', 'brothel keeper',
       'head prostitute', 'head', 'quick', 'strong', 'survivor', 'voice',
       'nights watchman', 'male voice', 'nights watchmen',
       'maester wolkan', 'bolton officer', 'septa unella', 'maester',
       'listeners', 'red priest', 'bloodrider', 'wife', 'khal moro',
       'young rodrik', 'young ned', 'young benjen', 'young lyanna',
       'young hodor', 'child of forest', 'storyteller', 'kings soldier',
       'lord karstark', 'lady walda', 'hooded figure', 'euron greyjoy',
       'aeron', 'arthur', 'dothraki woman', 'dothraki matron', 'vala',
       'maester pycelle', 'lady olenna', 'smalljon', 'bowen marsh',
       'othell yarwick', 'alliser throne', 'yezzan', 'razdal', 'belicho',
       'dothraki', 'leader', 'lhazareen woman', 'maester pycell', 'kevin',
       'khal', 'izembaro', 'clarenzo', 'ladyc rane', 'camello', 'bobono',
       'lady crane', 'bianca', 'leaf', 'aerson', 'kinvara', 'melessa',
       'talla', 'dickon', 'randyll', 'ray', 'sandor', 'dim dalba',
       'lyanna', 'robett', 'lem', 'gatins', 'young man', 'red priestess',
       'bryndel', 'guard captain', 'karstark', 'attendant', 'mistress',
       'vale knight', 'manderly', 'glover', 'waldery frey', 'yohn',
       'ned alys', 'wolkan', 'marwyn', 'little sam', 'ellia',
       'robett glover', 'lyanna mormont', 'drogon', 'archers',
       'archmaester', 'harrag', 'john royce', 'rhaegar', 'brans voice',
       'umber', 'harry', 'dirah', 'crayah', 'dothraki man', 'both',
       'teela', 'lyann', 'northman', 'martha', 'father', 'nora', 'vicky',
       'owen', 'riverlands lord', 'dornish prince', 'ironborn lord',
       'vale lord', 'unsullied captain'], dtype=object)

px['Name'].value_counts()

tyrion lannister        1760
jon snow                1133
daenerys targaryen      1048
cersei lannister        1005
jaime lannister          945
                        ... 
cohollo                    1
bystanders                 1
mountian                   1
bryndel                    1
shadow tower brother       1
Name: Name, Length: 564, dtype: int64

px['Name'].value_counts()

tyrion lannister        1760
jon snow                1133
daenerys targaryen      1048
cersei lannister        1005
jaime lannister          945
                        ... 
cohollo                    1
bystanders                 1
mountian                   1
bryndel                    1
shadow tower brother       1
Name: Name, Length: 564, dtype: int64

px['Name'].value_counts().index[0]

'tyrion lannister'

words = px.assign(Words=px['Sentence'].apply(lambda x:len(x.split()))).sort_values(by='Name')

lencount = []
numwords = list(zip(words['Name'],words['Words']))
for i in numwords:
    if i == numwords[0]:
        lencount.append(i[1])
        last = i[0]
    else:
        lencount.append(lencount[-1]+i[1] if i[0]==last else i[1])
        last = i[0]
words['Count'] = lencount
words['Name'][words['Count'].idxmax()]

'tyrion lannister'

pv = pd.read_csv('F:/data/Kobe_data.csv',index_col='shot_id')

pv.head()

	action_type	combined_shot_type	game_event_id	game_id	lat	loc_x	loc_y	lon	minutes_remaining	period	...	shot_made_flag	shot_type	shot_zone_area	shot_zone_basic	shot_zone_range	team_id	team_name	game_date	matchup	opponent
shot_id
1	Jump Shot	Jump Shot	10	20000012	33.9723	167	72	-118.1028	10	1	...	NaN	2PT Field Goal	Right Side(R)	Mid-Range	16-24 ft.	1610612747	Los Angeles Lakers	2000/10/31	LAL @ POR	POR
2	Jump Shot	Jump Shot	12	20000012	34.0443	-157	0	-118.4268	10	1	...	0.0	2PT Field Goal	Left Side(L)	Mid-Range	8-16 ft.	1610612747	Los Angeles Lakers	2000/10/31	LAL @ POR	POR
3	Jump Shot	Jump Shot	35	20000012	33.9093	-101	135	-118.3708	7	1	...	1.0	2PT Field Goal	Left Side Center(LC)	Mid-Range	16-24 ft.	1610612747	Los Angeles Lakers	2000/10/31	LAL @ POR	POR
4	Jump Shot	Jump Shot	43	20000012	33.8693	138	175	-118.1318	6	1	...	0.0	2PT Field Goal	Right Side Center(RC)	Mid-Range	16-24 ft.	1610612747	Los Angeles Lakers	2000/10/31	LAL @ POR	POR
5	Driving Dunk Shot	Dunk	155	20000012	34.0443	0	0	-118.2698	6	2	...	1.0	2PT Field Goal	Center(C)	Restricted Area	Less Than 8 ft.	1610612747	Los Angeles Lakers	2000/10/31	LAL @ POR	POR

5 rows × 24 columns

pv['action_type'].value_counts().head(1)

Jump Shot    18880
Name: action_type, dtype: int64

pv['combined_shot_type'].value_counts().head(1)

Jump Shot    23485
Name: combined_shot_type, dtype: int64

pd.Series(list(list(zip(*(pd.Series(list(zip(pv['game_id'],pv['opponent']))).unique()).tolist()))[1])).value_counts().index[0]

'SAS'