pandas, tabulate, and alignment

[menator01]

I been playing around with pandas and tabulate but, I am not able to figure out how to left align the text other than the first column.
I've searched and found workarounds/hacks using the styling configure and none seemed to work for me.
Using code from a previous post I participated in:

import pandas as pd
from tabulate import tabulate

class Portfolio:
    def __init__(self):
        self.holdings = {}

    def buy(self, ticker, shares):
        self.holdings[ticker] = self.holdings.get(ticker, 0) + shares

    def sell(self, ticker, shares):
        self.holdings[ticker] = self.holdings.get(ticker, 0) - shares

    def __iter__(self):
        return iter(self.holdings.items())


p = Portfolio()
p.buy('Alpha', 15)
p.buy('Beta', 23)
p.buy('Gamma', 9)
p.buy('Gamma', 20)
p.sell('Beta', 5)


df = pd.DataFrame(p)
df.columns=['Stock', 'Shares']
print(tabulate(df, showindex=False, headers=df.columns))
# print('\n\n')
# print(df.to_string(index=False))


# str_len = len(max(p)[0])
#
# for (ticker, shares) in p:
#     if len(ticker) < str_len:
#         spacer = ' '*(str_len - len(ticker) + 2)
#     else:
#         spacer = ' '*2
#     print(f'{ticker} {spacer} {shares}')

As you can see the first column is aligned to the left. How do I get the rest of the columns to align left, either with tabulate or pandas?
Thanks for any help.

[snippsat]

print(tabulate(df, showindex=False, headers=df.columns, numalign="left"))

Output:
Stock    Shares
-------  --------
Alpha    15
Beta     18
Gamma    29

Or use one of the fished format setup.

print(tabulate(df, showindex=False, headers=df.columns, tablefmt="pretty"))

Output:
+-------+--------+
| Stock | Shares |
+-------+--------+
| Alpha |   15   |
| Beta  |   18   |
| Gamma |   29   |
+-------+--------+

[bowlofred]

Tabulate has a description of column alignment on the module page. You should be able to either set a default for all numeric columns (or string columns), or you can set it for each column individually.

Try:

print(tabulate(df, showindex=False, headers=df.columns, numalign="left"))

[menator01]

Thanks guys. Guess I was making it harder that what it was.