How to display better Markdown tables   

In this post I want to share my experience with Markdown tables and pandas data frames. I wanted to format pandas data frames as Markdown tables unfortunately the original outlook is unreadable and ugly. You can compare the difference in the image below:

Let say that we have the next pandas dataframe and table. And you wanted to show it as Markdown table with better format including borders:

import pandas as pd
df = pd.DataFrame({'Date': ['08/09/2018', '10/09/2018', '09/09/2018', '04/09/2018', '08/09/2018', '10/09/2018',
                            '09/09/2018', '04/09/2018'],
                   'Company': ['Samsung', 'Samsung', 'Samsung', 'Samsung', 'Sony', 'Sony', 'Sony', 'Sony'],
                   'Promotions': [54, 56, 54, 4, 3, 34, 32, 15],
                   'Sells': [23, 34, 54, 6, 96, 45, 3, 12]})

print(df)

raw data frame output:

   Company        Date  Promotions  Sells  Total
0  Samsung  08/09/2018          54     23     57
1  Samsung  10/09/2018          56     34     90
2  Samsung  09/09/2018          54     54     86
3  Samsung  04/09/2018           4      6     19
4     Sony  08/09/2018           3     96     57
5     Sony  10/09/2018          34     45     90
6     Sony  09/09/2018          32      3     86
7     Sony  04/09/2018          15     12     19

table formatted after excel and using site conversion:

You can do this by:

• get the raw pandas output from your python console
• copy paste it in Excel, Libre Calc - by using text import and spaces
• use site conversion from Excel to Markdown table:
  • Markdown Tables Generator
  • Copy Table in Excel and Paste as a Markdown Table
• Paste the output to your Markdown page
• The final touch is to add borders to your Markdown file like:

<style>
table{
    border-collapse: collapse;
    border-spacing: 0;
    border:2px solid #000000;
}

th{
    border:2px solid #000000;
}

td{
    border:1px solid #000000;
}
</style>

For example if you use Ghost Blog you can do(for single post):

• Open the post for edit
• Settings of the post
• Code injection
• Post header
  • paste the code above

And now your Markdown tables/ pandas dataframes will be much more readable, user friendly and easy for the reader.