Understanding DataFrames Funtions
start of code
More Important Functions
# value_counts
# sort_values
# rank
# sort index
# set index
# rename index -> rename
# reset index
# unique & nunique
# isnull/notnull/hasnans
# dropna
# fillna
# drop_duplicates
# drop
# apply
# isin
# corr
# nlargest -> nsmallest
# insert
# copypython
import numpy as np
import pandas as pdpython
a = pd.Series([1,1,1,2,2,3])
a.value_counts()python
1 3 2 2 3 1 Name: count, dtype: int64
iq marks package 0 100 80 10 1 90 70 7 2 120 100 14 3 80 70 14 4 80 70 14
iq marks package 80 70 14 2 90 70 7 1 100 80 10 1 120 100 14 1 Name: count, dtype: int64
Player_of_Match F du Plessis 3 SK Raina 3 KA Pollard 3 JJ Bumrah 2 AB de Villiers 2 MK Pandey 2 M Vijay 2 A Kumble 2 YK Pathan 2 SR Watson 2 HH Pandya 1 RM Patidar 1 JC Buttler 1 RR Pant 1 KS Williamson 1 MP Stoinis 1 TA Boult 1 SP Narine 1 RD Gaikwad 1 VR Iyer 1 DA Miller 1 Washington Sundar 1 NM Coulter-Nile 1 KV Sharma 1 BCJ Cutting 1 KH Pandya 1 SA Yadav 1 Rashid Khan 1 AD Russell 1 RG Sharma 1 A Nehra 1 DA Warner 1 MC Henriques 1 Harbhajan Singh 1 BJ Hodge 1 UT Yadav 1 V Sehwag 1 MS Bisla 1 MEK Hussey 1 CH Gayle 1 MS Dhoni 1 MM Patel 1 DE Bollinger 1 AC Gilchrist 1 M Ntini 1 Name: count, dtype: int64
<Axes: ylabel='count'>
Mumbai Indians 231 Royal Challengers Bangalore 226 Kolkata Knight Riders 223 Chennai Super Kings 208 Rajasthan Royals 192 Kings XI Punjab 190 Delhi Daredevils 161 Sunrisers Hyderabad 152 Deccan Chargers 75 Delhi Capitals 63 Pune Warriors 46 Gujarat Lions 30 Punjab Kings 28 Gujarat Titans 16 Rising Pune Supergiant 16 Lucknow Super Giants 15 Kochi Tuskers Kerala 14 Rising Pune Supergiants 14 Name: count, dtype: int64
0 12 1 14 2 1 3 56 4 89 dtype: int64
4 89 3 56 1 14 0 12 2 1 dtype: int64
title_x imdb_id \
0 Uri: The Surgical Strike tt8291224
1 Battalion 609 tt9472208
2 The Accidental Prime Minister (film) tt6986710
3 Why Cheat India tt8108208
poster_path \
0 https://upload.wikimedia.org/wikipedia/en/thum...
1 NaN
2 https://upload.wikimedia.org/wikipedia/en/thum...
3 https://upload.wikimedia.org/wikipedia/en/thum...
wiki_link \
0 https://en.wikipedia.org/wiki/Uri:_The_Surgica...
1 https://en.wikipedia.org/wiki/Battalion_609
2 https://en.wikipedia.org/wiki/The_Accidental_P...
3 https://en.wikipedia.org/wiki/Why_Cheat_India
title_y original_title is_adult \
0 Uri: The Surgical Strike Uri: The Surgical Strike 0
1 Battalion 609 Battalion 609 0
2 The Accidental Prime Minister The Accidental Prime Minister 0
3 Why Cheat India Why Cheat India 0
year_of_release runtime genres imdb_rating imdb_votes \
0 2019 138 Action|Drama|War 8.4 35112
1 2019 131 War 4.1 73
2 2019 112 Biography|Drama 6.1 5549
3 2019 121 Crime|Drama 6.0 1891
story \
0 Divided over five chapters the film chronicle...
1 The story revolves around a cricket match betw...
2 Based on the memoir by Indian policy analyst S...
3 The movie focuses on existing malpractices in ...
summary tagline \
0 Indian army special forces execute a covert op... NaN
1 The story of Battalion 609 revolves around a c... NaN
2 Explores Manmohan Singh's tenure as the Prime ... NaN
3 The movie focuses on existing malpractices in ... NaN
actors wins_nominations \
0 Vicky Kaushal|Paresh Rawal|Mohit Raina|Yami Ga... 4 wins
1 Vicky Ahuja|Shoaib Ibrahim|Shrikant Kamat|Elen... NaN
2 Anupam Kher|Akshaye Khanna|Aahana Kumra|Atul S... NaN
3 Emraan Hashmi|Shreya Dhanwanthary|Snighdadeep ... NaN
release_date
0 11 January 2019 (USA)
1 11 January 2019 (India)
2 11 January 2019 (USA)
3 18 January 2019 (USA) title_x imdb_id \
1623 Zubeidaa tt0255713
939 Zor Lagaa Ke...Haiya! tt1479857
756 Zokkomon tt1605790
670 Zindagi Tere Naam tt2164702
778 Zindagi Na Milegi Dobara tt1562872
... ... ...
1039 1971 (2007 film) tt0983990
723 1920: The Evil Returns tt2222550
287 1920: London tt5638500
1021 1920 (film) tt1301698
1498 16 December (film) tt0313844
poster_path \
1623 https://upload.wikimedia.org/wikipedia/en/thum...
939 https://upload.wikimedia.org/wikipedia/en/thum...
756 https://upload.wikimedia.org/wikipedia/en/thum...
670 https://upload.wikimedia.org/wikipedia/en/thum...
778 https://upload.wikimedia.org/wikipedia/en/thum...
... ...
1039 https://upload.wikimedia.org/wikipedia/en/thum...
723 https://upload.wikimedia.org/wikipedia/en/e/e7...
287 https://upload.wikimedia.org/wikipedia/en/thum...
1021 https://upload.wikimedia.org/wikipedia/en/thum...
1498 https://upload.wikimedia.org/wikipedia/en/thum...
wiki_link \
1623 https://en.wikipedia.org/wiki/Zubeidaa
939 https://en.wikipedia.org/wiki/Zor_Lagaa_Ke...H...
756 https://en.wikipedia.org/wiki/Zokkomon
670 https://en.wikipedia.org/wiki/Zindagi_Tere_Naam
778 https://en.wikipedia.org/wiki/Zindagi_Na_Mileg...
... ...
1039 https://en.wikipedia.org/wiki/1971_(2007_film)
723 https://en.wikipedia.org/wiki/1920:_The_Evil_R...
287 https://en.wikipedia.org/wiki/1920_London
1021 https://en.wikipedia.org/wiki/1920_(film)
1498 https://en.wikipedia.org/wiki/16_December_(film)
title_y original_title is_adult \
1623 Zubeidaa Zubeidaa 0
939 Zor Lagaa Ke... Haiya! Zor Lagaa Ke... Haiya! 0
756 Zokkomon Zokkomon 0
670 Zindagi Tere Naam Zindagi Tere Naam 0
778 Zindagi Na Milegi Dobara Zindagi Na Milegi Dobara 0
... ... ... ...
1039 1971 1971 0
723 1920: Evil Returns 1920: Evil Returns 0
287 1920 London 1920 London 0
1021 1920 1920 0
1498 16-Dec 16-Dec 0
year_of_release runtime genres imdb_rating \
1623 2001 153 Biography|Drama|History 6.2
939 2009 \N Comedy|Drama|Family 6.4
756 2011 109 Action|Adventure 4.0
670 2012 120 Romance 4.7
778 2011 155 Comedy|Drama 8.1
... ... ... ... ...
1039 2007 160 Action|Drama|War 7.9
723 2012 124 Drama|Horror|Romance 4.8
287 2016 120 Horror|Mystery 4.1
1021 2008 138 Horror|Mystery|Romance 6.4
1498 2002 158 Action|Thriller 6.9
imdb_votes story \
1623 1384 The film begins with Riyaz (Rajat Kapoor) Zub...
939 46 A tree narrates the story of four Mumbai-based...
756 274 After the passing of his parents in an acciden...
670 27 Mr. Singh an elderly gentleman relates to hi...
778 60826 Three friends decide to turn their fantasy vac...
... ... ...
1039 1121 Based on true facts the film revolves around ...
723 1587 This story revolves around a famous poet who m...
287 1373 Shivangi (Meera Chopra) lives in London with h...
1021 2588 A devotee of Bhagwan Shri Hanuman Arjun Singh...
1498 1091 16 December 1971 was the day when India won t...
summary \
1623 Zubeidaa an aspiring Muslim actress marries ...
939 Children build a tree-house to spy on a beggar...
756 An orphan is abused and abandoned believed to...
670 Mr. Singh an elderly gentleman relates to hi...
778 Three friends decide to turn their fantasy vac...
... ...
1039 Based on true facts the film revolves around ...
723 This story revolves around a famous poet who m...
287 After her husband is possessed by an evil spir...
1021 After forsaking his family and religion a hus...
1498 Indian intelligence agents race against time t...
tagline \
1623 The Story of a Princess
939 NaN
756 Betrayal. Friendship. Bravery.
670 NaN
778 NaN
... ...
1039 Honor the heroes.......
723 Possession is back
287 Fear strikes again
1021 A Love Made in Heaven...A Revenge Born in Hell...
1498 NaN
actors \
1623 Karisma Kapoor|Rekha|Manoj Bajpayee|Rajit Kapo...
939 Meghan Jadhav|Mithun Chakraborty|Riya Sen|Seem...
756 Darsheel Safary|Anupam Kher|Manjari Fadnnis|Ti...
670 Mithun Chakraborty|Ranjeeta Kaur|Priyanka Meht...
778 Hrithik Roshan|Farhan Akhtar|Abhay Deol|Katrin...
... ...
1039 Manoj Bajpayee|Ravi Kishan|Deepak Dobriyal|
723 Vicky Ahuja|Tia Bajpai|Irma Jämhammar|Sharad K...
287 Sharman Joshi|Meera Chopra|Vishal Karwal|Suren...
1021 Rajniesh Duggall|Adah Sharma|Anjori Alagh|Raj ...
1498 Danny Denzongpa|Gulshan Grover|Milind Soman|Di...
wins_nominations release_date
1623 3 wins & 13 nominations 19 January 2001 (India)
939 NaN NaN
756 NaN 22 April 2011 (India)
670 1 win 16 March 2012 (India)
778 30 wins & 22 nominations 15 July 2011 (India)
... ... ...
1039 1 win 9 March 2007 (India)
723 NaN 2 November 2012 (India)
287 NaN 6 May 2016 (USA)
1021 NaN 12 September 2008 (India)
1498 2 nominations 22 March 2002 (India)
[1629 rows x 18 columns]name college branch cgpa package 0 nitish bit eee 6.66 4.0 1 ankit iit it 8.25 5.0 2 rupesh vit cse 6.41 6.0 3 NaN NaN NaN NaN NaN 4 mrityunjay NaN me 5.60 6.0 5 NaN vlsi ce 9.00 7.0 6 rishabh ssit civ 7.40 8.0 7 NaN NaN cse 10.00 9.0 8 aditya NaN bio 7.40 NaN 9 NaN git NaN NaN NaN
name college branch cgpa package 3 NaN NaN NaN NaN NaN 5 NaN vlsi ce 9.00 7.0 7 NaN NaN cse 10.00 9.0 9 NaN git NaN NaN NaN 2 rupesh vit cse 6.41 6.0 6 rishabh ssit civ 7.40 8.0 0 nitish bit eee 6.66 4.0 4 mrityunjay NaN me 5.60 6.0 1 ankit iit it 8.25 5.0 8 aditya NaN bio 7.40 NaN
title_x imdb_id \
1623 Zubeidaa tt0255713
1625 Yeh Zindagi Ka Safar tt0298607
1622 Yeh Teraa Ghar Yeh Meraa Ghar tt0298606
1620 Yeh Raaste Hain Pyaar Ke tt0292740
1573 Yaadein (2001 film) tt0248617
... ... ...
37 Article 15 (film) tt10324144
46 Arjun Patiala tt7881524
10 Amavas tt8396186
26 Albert Pinto Ko Gussa Kyun Aata Hai? tt4355838
21 22 Yards tt9496212
poster_path \
1623 https://upload.wikimedia.org/wikipedia/en/thum...
1625 https://upload.wikimedia.org/wikipedia/en/thum...
1622 https://upload.wikimedia.org/wikipedia/en/thum...
1620 https://upload.wikimedia.org/wikipedia/en/thum...
1573 https://upload.wikimedia.org/wikipedia/en/thum...
... ...
37 https://upload.wikimedia.org/wikipedia/en/thum...
46 https://upload.wikimedia.org/wikipedia/en/thum...
10 https://upload.wikimedia.org/wikipedia/en/thum...
26 https://upload.wikimedia.org/wikipedia/en/thum...
21 https://upload.wikimedia.org/wikipedia/en/thum...
wiki_link \
1623 https://en.wikipedia.org/wiki/Zubeidaa
1625 https://en.wikipedia.org/wiki/Yeh_Zindagi_Ka_S...
1622 https://en.wikipedia.org/wiki/Yeh_Teraa_Ghar_Y...
1620 https://en.wikipedia.org/wiki/Yeh_Raaste_Hain_...
1573 https://en.wikipedia.org/wiki/Yaadein_(2001_film)
... ...
37 https://en.wikipedia.org/wiki/Article_15_(film)
46 https://en.wikipedia.org/wiki/Arjun_Patiala
10 https://en.wikipedia.org/wiki/Amavas
26 https://en.wikipedia.org/wiki/Albert_Pinto_Ko_...
21 https://en.wikipedia.org/wiki/22_Yards
title_y \
1623 Zubeidaa
1625 Yeh Zindagi Ka Safar
1622 Yeh Teraa Ghar Yeh Meraa Ghar
1620 Yeh Raaste Hain Pyaar Ke
1573 Yaadein...
... ...
37 Article 15
46 Arjun Patiala
10 Amavas
26 Albert Pinto Ko Gussa Kyun Aata Hai?
21 22 Yards
original_title is_adult year_of_release runtime \
1623 Zubeidaa 0 2001 153
1625 Yeh Zindagi Ka Safar 0 2001 146
1622 Yeh Teraa Ghar Yeh Meraa Ghar 0 2001 175
1620 Yeh Raaste Hain Pyaar Ke 0 2001 149
1573 Yaadein... 0 2001 171
... ... ... ... ...
37 Article 15 0 2019 130
46 Arjun Patiala 0 2019 107
10 Amavas 0 2019 134
26 Albert Pinto Ko Gussa Kyun Aata Hai? 0 2019 100
21 22 Yards 0 2019 126
genres imdb_rating imdb_votes \
1623 Biography|Drama|History 6.2 1384
1625 Drama 3.0 133
1622 Comedy|Drama 5.7 704
1620 Drama|Romance 4.0 607
1573 Drama|Musical|Romance 4.4 3034
... ... ... ...
37 Crime|Drama 8.3 13417
46 Action|Comedy 4.1 676
10 Horror|Thriller 2.8 235
26 Drama 4.8 56
21 Sport 5.3 124
story \
1623 The film begins with Riyaz (Rajat Kapoor) Zub...
1625 Hindi pop-star Sarina Devan lives a wealthy ...
1622 In debt; Dayashankar Pandey is forced to go to...
1620 Two con artistes and car thieves Vicky (Ajay ...
1573 Raj Singh Puri is best friends with L.K. Malho...
... ...
37 In the rural heartlands of India an upright p...
46 Arjun Patiala(Diljit Dosanjh)has recently been...
10 Far away from the bustle of the city a young ...
26 Albert leaves his house one morning without te...
21 A dramatic portrayal of a victorious tale of a...
summary \
1623 Zubeidaa an aspiring Muslim actress marries ...
1625 A singer finds out she was adopted when the ed...
1622 In debt; Dayashankar Pandey is forced to go to...
1620 Two con artistes and car thieves Vicky (Ajay ...
1573 Raj Singh Puri is best friends with L.K. Malho...
... ...
37 In the rural heartlands of India an upright p...
46 This spoof comedy narrates the story of a cop ...
10 The lives of a couple turn into a nightmare a...
26 Albert Pinto goes missing one day and his girl...
21 A dramatic portrayal of a victorious tale of a...
tagline \
1623 The Story of a Princess
1625 NaN
1622 NaN
1620 Love is a journey... not a destination
1573 memories to cherish...
... ...
37 Farq Bahut Kar Liya| Ab Farq Laayenge.
46 NaN
10 NaN
26 NaN
21 NaN
actors \
1623 Karisma Kapoor|Rekha|Manoj Bajpayee|Rajit Kapo...
1625 Ameesha Patel|Jimmy Sheirgill|Nafisa Ali|Gulsh...
1622 Sunil Shetty|Mahima Chaudhry|Paresh Rawal|Saur...
1620 Ajay Devgn|Madhuri Dixit|Preity Zinta|Vikram G...
1573 Jackie Shroff|Hrithik Roshan|Kareena Kapoor|Am...
... ...
37 Ayushmann Khurrana|Nassar|Manoj Pahwa|Kumud Mi...
46 Diljit Dosanjh|Kriti Sanon|Varun Sharma|Ronit ...
10 Ali Asgar|Vivan Bhatena|Nargis Fakhri|Sachiin ...
26 Manav Kaul|Nandita Das|
21 Barun Sobti|Rajit Kapur|Panchhi Bora|Kartikey ...
wins_nominations release_date
1623 3 wins & 13 nominations 19 January 2001 (India)
1625 NaN 16 November 2001 (India)
1622 1 nomination 12 October 2001 (India)
1620 NaN 10 August 2001 (India)
1573 1 nomination 27 June 2001 (India)
... ... ...
37 1 win 28 June 2019 (USA)
46 NaN 26 July 2019 (USA)
10 NaN 8 February 2019 (India)
26 NaN 12 April 2019 (India)
21 NaN 15 March 2019 (India)
[1629 rows x 18 columns]batter batsman_run 0 A Ashish Reddy 280 1 A Badoni 161 2 A Chandila 4 3 A Chopra 53 4 A Choudhary 25
batter batsman_run batsman_rank 569 V Kohli 6634 1.0 462 S Dhawan 6244 2.0 130 DA Warner 5883 3.0 430 RG Sharma 5881 4.0 493 SK Raina 5536 5.0 .. ... ... ... 570 V Pratap Singh 0 594.0 63 Abdur Razzak 0 594.0 562 U Kaul 0 594.0 65 Akash Deep 0 594.0 57 AS Roy 0 594.0 [605 rows x 3 columns]
maths 67 english 57 science 89 hindi 100 dtype: int64
science 89 maths 67 hindi 100 english 57 dtype: int64
title_x imdb_id \
1628 Humsafar tt2403201
1627 Daaka tt10833860
1626 Sabse Bada Sukh tt0069204
1625 Yeh Zindagi Ka Safar tt0298607
1624 Tera Mera Saath Rahen tt0301250
... ... ...
4 Evening Shadows tt6028796
3 Why Cheat India tt8108208
2 The Accidental Prime Minister (film) tt6986710
1 Battalion 609 tt9472208
0 Uri: The Surgical Strike tt8291224
poster_path \
1628 https://upload.wikimedia.org/wikipedia/en/thum...
1627 https://upload.wikimedia.org/wikipedia/en/thum...
1626 NaN
1625 https://upload.wikimedia.org/wikipedia/en/thum...
1624 https://upload.wikimedia.org/wikipedia/en/2/2b...
... ...
4 NaN
3 https://upload.wikimedia.org/wikipedia/en/thum...
2 https://upload.wikimedia.org/wikipedia/en/thum...
1 NaN
0 https://upload.wikimedia.org/wikipedia/en/thum...
wiki_link \
1628 https://en.wikipedia.org/wiki/Humsafar
1627 https://en.wikipedia.org/wiki/Daaka
1626 https://en.wikipedia.org/wiki/Sabse_Bada_Sukh
1625 https://en.wikipedia.org/wiki/Yeh_Zindagi_Ka_S...
1624 https://en.wikipedia.org/wiki/Tera_Mera_Saath_...
... ...
4 https://en.wikipedia.org/wiki/Evening_Shadows
3 https://en.wikipedia.org/wiki/Why_Cheat_India
2 https://en.wikipedia.org/wiki/The_Accidental_P...
1 https://en.wikipedia.org/wiki/Battalion_609
0 https://en.wikipedia.org/wiki/Uri:_The_Surgica...
title_y original_title is_adult \
1628 Humsafar Humsafar 0
1627 Daaka Daaka 0
1626 Sabse Bada Sukh Sabse Bada Sukh 0
1625 Yeh Zindagi Ka Safar Yeh Zindagi Ka Safar 0
1624 Tera Mera Saath Rahen Tera Mera Saath Rahen 0
... ... ... ...
4 Evening Shadows Evening Shadows 0
3 Why Cheat India Why Cheat India 0
2 The Accidental Prime Minister The Accidental Prime Minister 0
1 Battalion 609 Battalion 609 0
0 Uri: The Surgical Strike Uri: The Surgical Strike 0
year_of_release runtime genres imdb_rating imdb_votes \
1628 2011 35 Drama|Romance 9.0 2968
1627 2019 136 Action 7.4 38
1626 2018 \N Comedy|Drama 6.1 13
1625 2001 146 Drama 3.0 133
1624 2001 148 Drama 4.9 278
... ... ... ... ... ...
4 2018 102 Drama 7.3 280
3 2019 121 Crime|Drama 6.0 1891
2 2019 112 Biography|Drama 6.1 5549
1 2019 131 War 4.1 73
0 2019 138 Action|Drama|War 8.4 35112
story \
1628 Sara and Ashar are childhood friends who share...
1627 Shinda tries robbing a bank so he can be wealt...
1626 Village born Lalloo re-locates to Bombay and ...
1625 Hindi pop-star Sarina Devan lives a wealthy ...
1624 Raj Dixit lives with his younger brother Rahu...
... ...
4 While gay rights and marriage equality has bee...
3 The movie focuses on existing malpractices in ...
2 Based on the memoir by Indian policy analyst S...
1 The story revolves around a cricket match betw...
0 Divided over five chapters the film chronicle...
summary tagline \
1628 Ashar and Khirad are forced to get married due... NaN
1627 Shinda tries robbing a bank so he can be wealt... NaN
1626 Village born Lalloo re-locates to Bombay and ... NaN
1625 A singer finds out she was adopted when the ed... NaN
1624 A man is torn between his handicapped brother ... NaN
... ... ...
4 Under the 'Evening Shadows' truth often plays... NaN
3 The movie focuses on existing malpractices in ... NaN
2 Explores Manmohan Singh's tenure as the Prime ... NaN
1 The story of Battalion 609 revolves around a c... NaN
0 Indian army special forces execute a covert op... NaN
actors \
1628 Fawad Khan|
1627 Gippy Grewal|Zareen Khan|
1626 Vijay Arora|Asrani|Rajni Bala|Kumud Damle|Utpa...
1625 Ameesha Patel|Jimmy Sheirgill|Nafisa Ali|Gulsh...
1624 Ajay Devgn|Sonali Bendre|Namrata Shirodkar|Pre...
... ...
4 Mona Ambegaonkar|Ananth Narayan Mahadevan|Deva...
3 Emraan Hashmi|Shreya Dhanwanthary|Snighdadeep ...
2 Anupam Kher|Akshaye Khanna|Aahana Kumra|Atul S...
1 Vicky Ahuja|Shoaib Ibrahim|Shrikant Kamat|Elen...
0 Vicky Kaushal|Paresh Rawal|Mohit Raina|Yami Ga...
wins_nominations release_date
1628 NaN TV Series (2011–2012)
1627 NaN 1 November 2019 (USA)
1626 NaN NaN
1625 NaN 16 November 2001 (India)
1624 NaN 7 November 2001 (India)
... ... ...
4 17 wins & 1 nomination 11 January 2019 (India)
3 NaN 18 January 2019 (USA)
2 NaN 11 January 2019 (USA)
1 NaN 11 January 2019 (India)
0 4 wins 11 January 2019 (USA)
[1629 rows x 18 columns]batsman_run batsman_rank batter A Ashish Reddy 280 166.5 A Badoni 161 226.0 A Chandila 4 535.0 A Chopra 53 329.0 A Choudhary 25 402.5 ... ... ... Yash Dayal 0 594.0 Yashpal Singh 47 343.0 Younis Khan 3 547.5 Yuvraj Singh 2754 27.0 Z Khan 117 256.0 [605 rows x 2 columns]
batter batsman_run batsman_rank 0 A Ashish Reddy 280 166.5 1 A Badoni 161 226.0 2 A Chandila 4 535.0 3 A Chopra 53 329.0 4 A Choudhary 25 402.5 .. ... ... ... 600 Yash Dayal 0 594.0 601 Yashpal Singh 47 343.0 602 Younis Khan 3 547.5 603 Yuvraj Singh 2754 27.0 604 Z Khan 117 256.0 [605 rows x 3 columns]
batter batsman_run batsman_rank 166.5 A Ashish Reddy 280 226.0 A Badoni 161 535.0 A Chandila 4 329.0 A Chopra 53 402.5 A Choudhary 25 ... ... ... 594.0 Yash Dayal 0 343.0 Yashpal Singh 47 547.5 Younis Khan 3 27.0 Yuvraj Singh 2754 256.0 Z Khan 117 [605 rows x 2 columns]
index 0 0 maths 67 1 english 57 2 science 89 3 hindi 100
imdb \
title_x
Uri tt8291224
Battalion tt9472208
The Accidental Prime Minister (film) tt6986710
Why Cheat India tt8108208
Evening Shadows tt6028796
... ...
Tera Mera Saath Rahen tt0301250
Yeh Zindagi Ka Safar tt0298607
Sabse Bada Sukh tt0069204
Daaka tt10833860
Humsafar tt2403201
link \
title_x
Uri https://upload.wikimedia.org/wikipedia/en/thum...
Battalion NaN
The Accidental Prime Minister (film) https://upload.wikimedia.org/wikipedia/en/thum...
Why Cheat India https://upload.wikimedia.org/wikipedia/en/thum...
Evening Shadows NaN
... ...
Tera Mera Saath Rahen https://upload.wikimedia.org/wikipedia/en/2/2b...
Yeh Zindagi Ka Safar https://upload.wikimedia.org/wikipedia/en/thum...
Sabse Bada Sukh NaN
Daaka https://upload.wikimedia.org/wikipedia/en/thum...
Humsafar https://upload.wikimedia.org/wikipedia/en/thum...
wiki_link \
title_x
Uri https://en.wikipedia.org/wiki/Uri:_The_Surgica...
Battalion https://en.wikipedia.org/wiki/Battalion_609
The Accidental Prime Minister (film) https://en.wikipedia.org/wiki/The_Accidental_P...
Why Cheat India https://en.wikipedia.org/wiki/Why_Cheat_India
Evening Shadows https://en.wikipedia.org/wiki/Evening_Shadows
... ...
Tera Mera Saath Rahen https://en.wikipedia.org/wiki/Tera_Mera_Saath_...
Yeh Zindagi Ka Safar https://en.wikipedia.org/wiki/Yeh_Zindagi_Ka_S...
Sabse Bada Sukh https://en.wikipedia.org/wiki/Sabse_Bada_Sukh
Daaka https://en.wikipedia.org/wiki/Daaka
Humsafar https://en.wikipedia.org/wiki/Humsafar
title_y \
title_x
Uri Uri: The Surgical Strike
Battalion Battalion 609
The Accidental Prime Minister (film) The Accidental Prime Minister
Why Cheat India Why Cheat India
Evening Shadows Evening Shadows
... ...
Tera Mera Saath Rahen Tera Mera Saath Rahen
Yeh Zindagi Ka Safar Yeh Zindagi Ka Safar
Sabse Bada Sukh Sabse Bada Sukh
Daaka Daaka
Humsafar Humsafar
original_title is_adult \
title_x
Uri Uri: The Surgical Strike 0
Battalion Battalion 609 0
The Accidental Prime Minister (film) The Accidental Prime Minister 0
Why Cheat India Why Cheat India 0
Evening Shadows Evening Shadows 0
... ... ...
Tera Mera Saath Rahen Tera Mera Saath Rahen 0
Yeh Zindagi Ka Safar Yeh Zindagi Ka Safar 0
Sabse Bada Sukh Sabse Bada Sukh 0
Daaka Daaka 0
Humsafar Humsafar 0
year_of_release runtime \
title_x
Uri 2019 138
Battalion 2019 131
The Accidental Prime Minister (film) 2019 112
Why Cheat India 2019 121
Evening Shadows 2018 102
... ... ...
Tera Mera Saath Rahen 2001 148
Yeh Zindagi Ka Safar 2001 146
Sabse Bada Sukh 2018 \N
Daaka 2019 136
Humsafar 2011 35
genres imdb_rating \
title_x
Uri Action|Drama|War 8.4
Battalion War 4.1
The Accidental Prime Minister (film) Biography|Drama 6.1
Why Cheat India Crime|Drama 6.0
Evening Shadows Drama 7.3
... ... ...
Tera Mera Saath Rahen Drama 4.9
Yeh Zindagi Ka Safar Drama 3.0
Sabse Bada Sukh Comedy|Drama 6.1
Daaka Action 7.4
Humsafar Drama|Romance 9.0
imdb_votes \
title_x
Uri 35112
Battalion 73
The Accidental Prime Minister (film) 5549
Why Cheat India 1891
Evening Shadows 280
... ...
Tera Mera Saath Rahen 278
Yeh Zindagi Ka Safar 133
Sabse Bada Sukh 13
Daaka 38
Humsafar 2968
story \
title_x
Uri Divided over five chapters the film chronicle...
Battalion The story revolves around a cricket match betw...
The Accidental Prime Minister (film) Based on the memoir by Indian policy analyst S...
Why Cheat India The movie focuses on existing malpractices in ...
Evening Shadows While gay rights and marriage equality has bee...
... ...
Tera Mera Saath Rahen Raj Dixit lives with his younger brother Rahu...
Yeh Zindagi Ka Safar Hindi pop-star Sarina Devan lives a wealthy ...
Sabse Bada Sukh Village born Lalloo re-locates to Bombay and ...
Daaka Shinda tries robbing a bank so he can be wealt...
Humsafar Sara and Ashar are childhood friends who share...
summary \
title_x
Uri Indian army special forces execute a covert op...
Battalion The story of Battalion 609 revolves around a c...
The Accidental Prime Minister (film) Explores Manmohan Singh's tenure as the Prime ...
Why Cheat India The movie focuses on existing malpractices in ...
Evening Shadows Under the 'Evening Shadows' truth often plays...
... ...
Tera Mera Saath Rahen A man is torn between his handicapped brother ...
Yeh Zindagi Ka Safar A singer finds out she was adopted when the ed...
Sabse Bada Sukh Village born Lalloo re-locates to Bombay and ...
Daaka Shinda tries robbing a bank so he can be wealt...
Humsafar Ashar and Khirad are forced to get married due...
tagline \
title_x
Uri NaN
Battalion NaN
The Accidental Prime Minister (film) NaN
Why Cheat India NaN
Evening Shadows NaN
... ...
Tera Mera Saath Rahen NaN
Yeh Zindagi Ka Safar NaN
Sabse Bada Sukh NaN
Daaka NaN
Humsafar NaN
actors \
title_x
Uri Vicky Kaushal|Paresh Rawal|Mohit Raina|Yami Ga...
Battalion Vicky Ahuja|Shoaib Ibrahim|Shrikant Kamat|Elen...
The Accidental Prime Minister (film) Anupam Kher|Akshaye Khanna|Aahana Kumra|Atul S...
Why Cheat India Emraan Hashmi|Shreya Dhanwanthary|Snighdadeep ...
Evening Shadows Mona Ambegaonkar|Ananth Narayan Mahadevan|Deva...
... ...
Tera Mera Saath Rahen Ajay Devgn|Sonali Bendre|Namrata Shirodkar|Pre...
Yeh Zindagi Ka Safar Ameesha Patel|Jimmy Sheirgill|Nafisa Ali|Gulsh...
Sabse Bada Sukh Vijay Arora|Asrani|Rajni Bala|Kumud Damle|Utpa...
Daaka Gippy Grewal|Zareen Khan|
Humsafar Fawad Khan|
wins_nominations \
title_x
Uri 4 wins
Battalion NaN
The Accidental Prime Minister (film) NaN
Why Cheat India NaN
Evening Shadows 17 wins & 1 nomination
... ...
Tera Mera Saath Rahen NaN
Yeh Zindagi Ka Safar NaN
Sabse Bada Sukh NaN
Daaka NaN
Humsafar NaN
release_date
title_x
Uri 11 January 2019 (USA)
Battalion 11 January 2019 (India)
The Accidental Prime Minister (film) 11 January 2019 (USA)
Why Cheat India 18 January 2019 (USA)
Evening Shadows 11 January 2019 (India)
... ...
Tera Mera Saath Rahen 7 November 2001 (India)
Yeh Zindagi Ka Safar 16 November 2001 (India)
Sabse Bada Sukh NaN
Daaka 1 November 2019 (USA)
Humsafar TV Series (2011–2012)
[1629 rows x 17 columns]0 1.0 1 1.0 2 2.0 3 2.0 4 3.0 5 3.0 6 4.0 7 4.0 8 5.0 9 5.0 10 NaN 11 NaN dtype: float64
array([ 1., 2., 3., 4., 5., nan])
6