How to use pandas to read csv files in python?

Asked Jun 08 '18 at 12:34

Active Jun 08 '18 at 12:51

Viewed 46 times

When I try to read a csv fie using the code pandas.read_csv("data.csv") the result is not shown in a table with borders only like this;

               Class  CTLA4   PD1  PD1CTLA4  CD57  CD57+CD28-  PD1CD57  
44  ASYMPTOMATIC_CD4   0.67  1.57     0.160  0.00        0.00    0.000   
45  ASYMPTOMATIC_CD4   0.50  0.64     0.110  2.46        2.39    0.036   
46  ASYMPTOMATIC_CD4   0.67  0.45     0.220  1.56        1.29    0.130

What code do I need to write to make Spyder show the csv file as a proper table with border lines?

edited Jun 08 '18 at 12:51

Andrei Suvorkov

5,559
5
22
48

asked Jun 08 '18 at 12:34

Ama Owusu-Darko

What is your separator? whitespace? – jezrael Jun 08 '18 at 12:38
@Ama Owusu-Darko - Do you need table format border in your print statment? – Mohamed Thasin ah Jun 08 '18 at 12:42
@MohamedThasinah Yes, how do I get the table format border instead of the whitespace as a separator? – Ama Owusu-Darko Jun 08 '18 at 14:05
@Ama Owusu-Darko - use tabulate package. For example to get border use this, print tabulate(df, df.columns,tablefmt='grid'). For more details visit https://pypi.org/project/tabulate/ – Mohamed Thasin ah Jun 08 '18 at 14:52
Thank you. (Sorry for late reply) – Ama Owusu-Darko Dec 09 '19 at 17:08

How to use pandas to read csv files in python?

0 Answers0