display np.int64 numbers as integers, do not apply 'floatfmt' about python-tabulate HOT 1 CLOSED

Hey @astanin, I appreciate the package, but just wanted to let you know that pandas DataFrames np.int64 numbers are still evaluated as float when there are other float columns. This is because this call to values causes numpy to upcast all integer columns to float columns. Ideally instead of just using the values, each cell would be considered individually.

I'm using a quick and dirty hack to get around this by reapplying the appropriate dtype to each cell afterwards here:

rows = [list([tabular_data.dtypes[tabular_data.keys()[i]].type(cell) for i, cell in enumerate(row)]) for row in vals]

This is probably unsafe in ways I don't know, but it does allow me to print the issue's primary example correctly (without this hack it still prints the output the original reported posted):

from tabulate import tabulate
import pandas as pd
df = pd.DataFrame({'A':[1,2,3,4],'B':[.20942, .092384, .019823, .01923]})
print(tabulate(df, floatfmt='.2f', headers=df.columns, tablefmt='pipe'))

|    |   A |    B |
|---:|----:|-----:|
|  0 |   1 | 0.21 |
|  1 |   2 | 0.09 |
|  2 |   3 | 0.02 |
|  3 |   4 | 0.02 |

from python-tabulate.