print small DataFrame to STDOUT and read it back into dataframe

[Luca]

On 4/6/2020 11:05 PM, Luca wrote:
> On 4/6/2020 8:51 PM, Reto wrote:
>> out = df.to_csv(None)
>> new = pd.read_csv(io.StringIO(out), index_col=0)
> 
> Thank you, brother. It works
> 

BTW, a little gotcha (I write this in case someone gets here in the 
future through Google or something)

"""
import pandas as pd
import numpy as np
import io
df = pd.DataFrame(10*np.random.randn(3,4))
df = df.astype(int)
out = df.to_csv(None)

# out == ',0,1,2,3\n0,9,4,-5,-2\n1,16,12,-1,-5\n2,-2,8,0,6\n'

new = pd.read_csv(io.StringIO(out), index_col=0)

#gotcha
type(df.iloc[1,1]) # numpy.int32
type(new.iloc[1,1]) # numpy.int64
"""

new == out will return a dataframe of False

         0	1	2	3
0	False	False	False	False
1	False	False	False	False
2	False	False	False	False

Thanks again