In [59]:

    

# pickle test
import pickle
import pandas as pd
import os
import zlib

this_dir = os.getcwd()

mydata = {'col1':[1,2,3],'col2':[4,5, 6], 'col3':['abc','def','ghi']}

mydata


    

    
Out[59]:





{'col1': [1, 2, 3], 'col2': [4, 5, 6], 'col3': ['abc', 'def', 'ghi']}

In [60]:

    

df = pd.DataFrame(mydata)
df


    

    
Out[60]:






  

    

      

      
col1
      
col2
      
col3
    
  
  

    

      
0
      
 1
      
 4
      
 abc
    
    

      
1
      
 2
      
 5
      
 def
    
    

      
2
      
 3
      
 6
      
 ghi
    
  

In [62]:

    

with open(this_dir + '/mypickle.py', 'wb')  as pickle_file:
    pkle_string = zlib.compress(pickle.dumps(df))
    pickle_file.write(pkle_string)
    pickle_file.close()

df[1,'col1']=999
df


    

    
Out[62]:






  

    

      

      
col1
      
col2
      
col3
      
(1, col1)
    
  
  

    

      
0
      
 1
      
 4
      
 abc
      
 999
    
    

      
1
      
 2
      
 5
      
 def
      
 999
    
    

      
2
      
 3
      
 6
      
 ghi
      
 999
    
  

In [63]:

    

# get pickled file
with open(this_dir + '/mypickle.py','rb') as pickle_file2:
    pkle_string = pickle_file2.read()
    df2= pickle.loads(zlib.decompress(pkle_string))


    

In [52]:

    

df2


    

    
Out[52]:






  

    

      

      
col1
      
col2
      
col3
    
  
  

    

      
0
      
 1
      
 4
      
 abc
    
    

      
1
      
 2
      
 5
      
 def
    
    

      
2
      
 3
      
 6
      
 ghi
    
  

In [ ]: