pandas - 特别篇(关于读取DataFrame数据显示不完全的解决办法)

今天在做数据处理的时候，发现，pandas.read_csv()读出来的数据，因为数据量太大，行列之前做了省略处理。

     Rank                    Title  ... Revenue (Millions) Metascore
0       1  Guardians of the Galaxy  ...             333.13      76.0
1       2               Prometheus  ...             126.46      65.0
2       3                    Split  ...             138.12      62.0
3       4                     Sing  ...             270.32      59.0
4       5            Suicide Squad  ...             325.02      40.0
..    ...                      ...  ...                ...       ...
995   996     Secret in Their Eyes  ...                NaN      45.0
996   997          Hostel: Part II  ...              17.54      46.0
997   998   Step Up 2: The Streets  ...              58.01      50.0
998   999             Search Party  ...                NaN      22.0
999  1000               Nine Lives  ...              19.64      11.0

[1000 rows x 12 columns]

就像这样，其中大多数的数据都被省略号给代替了

那应该怎么解决呢？查阅官方文档之后发现，这个问题可以通过pandas内置的set_option()方法解决，

从上面的属性设置中可以看到，与显示的行数列数有关的选项主要是[display]中的code[max_columns,max_rows,max_colwidth,line_width]等这几项，只需要将这几项属性值设置得大一些就可以解决。

具体代码

#导入模块
import pandas as pd

#设置中文字体路径
my_font = font_manager.FontProperties(fname="C:\Windows\Fonts\msyh.ttc")

#设置显示范围
pd.set_option('display.max_columns', 1000)

pd.set_option('display.width', 1000)

pd.set_option('display.max_colwidth', 1000)

得到结果

     Rank                    Title                     Genre                                                                                                                                                                                                                     Description              Director                                                                      Actors  Year  Runtime (Minutes)  Rating   Votes  Revenue (Millions)  Metascore
0       1  Guardians of the Galaxy   Action,Adventure,Sci-Fi                                                                                                 A group of intergalactic criminals are forced to work together to stop a fanatical warrior from taking control of the universe.            James Gunn                        Chris Pratt, Vin Diesel, Bradley Cooper, Zoe Saldana  2014                121     8.1  757074              333.13       76.0
1       2               Prometheus  Adventure,Mystery,Sci-Fi                                                                                                 Following clues to the origin of mankind, a team finds a structure on a distant moon, but they soon realize they are not alone.          Ridley Scott     Noomi Rapace, Logan Marshall-Green, Michael Fassbender, Charlize Theron  2012                124     7.0  485820              126.46       65.0
2       3                    Split           Horror,Thriller                                                                   Three girls are kidnapped by a man with a diagnosed 23 distinct personalities. They must try to escape before the apparent emergence of a frightful new 24th.    M. Night Shyamalan            James McAvoy, Anya Taylor-Joy, Haley Lu Richardson, Jessica Sula  2016                117     7.3  157606              138.12       62.0
3       4                     Sing   Animation,Comedy,Family  In a city of humanoid animals, a hustling theater impresario's attempt to save his theater with a singing competition becomes grander than he anticipates even as its finalists' find that their lives will never be the same.  Christophe Lourdelet  Matthew McConaughey,Reese Witherspoon, Seth MacFarlane, Scarlett Johansson  2016                108     7.2   60545              270.32       59.0
4       5            Suicide Squad  Action,Adventure,Fantasy                                             A secret government agency recruits some of the most dangerous incarcerated super-villains to form a defensive task force. Their first mission: save the world from the apocalypse.            David Ayer                          Will Smith, Jared Leto, Margot Robbie, Viola Davis  2016                123     6.2  393727              325.02       40.0
..    ...                      ...                       ...                                                                                                                                                                                                                             ...                   ...                                                                         ...   ...                ...     ...     ...                 ...        ...
995   996     Secret in Their Eyes       Crime,Drama,Mystery                                           A tight-knit team of rising investigators, along with their supervisor, is suddenly torn apart when they discover that one of their own teenage daughters has been brutally murdered.             Billy Ray                 Chiwetel Ejiofor, Nicole Kidman, Julia Roberts, Dean Norris  2015                111     6.2   27585                 NaN       45.0
996   997          Hostel: Part II                    Horror                                                                                                       Three American college students studying abroad are lured to a Slovakian hostel, and discover the grim reality behind it.              Eli Roth                Lauren German, Heather Matarazzo, Bijou Phillips, Roger Bart  2007                 94     5.5   73152               17.54       46.0
997   998   Step Up 2: The Streets       Drama,Music,Romance                                                                                                                 Romantic sparks occur between two dance students from different backgrounds at the Maryland School of the Arts.            Jon M. Chu               Robert Hoffman, Briana Evigan, Cassie Ventura, Adam G. Sevani  2008                 98     6.2   70699               58.01       50.0
998   999             Search Party          Adventure,Comedy                                                                                                                                A pair of friends embark on a mission to reunite their pal with the woman he was going to marry.        Scot Armstrong                Adam Pally, T.J. Miller, Thomas Middleditch,Shannon Woodward  2014                 93     5.6    4881                 NaN       22.0
999  1000               Nine Lives     Comedy,Family,Fantasy                                                                                                                                                 A stuffy businessman finds himself trapped inside the body of his family's cat.      Barry Sonnenfeld                    Kevin Spacey, Jennifer Garner, Robbie Amell,Cheryl Hines  2016                 87     5.3   12435               19.64       11.0

[1000 rows x 12 columns]

问题就迎刃而解了~~~