기본 IO

  1. IO
  2. 기본 IO


import os, sys
import pandas as pd

basePath = r'D:\'

fileName = os.path.join( basePath,  'AAA.xlsx' )
data = pd.read_excel( fileName , sheet_name= 'BBB' )


fileName = os.path.join( basePath,   ( 'export' + '.xlsx' )  )
data = data.iloc[:1000000]
data.to_excel(fileName, index=False)




fileName = os.path.join( basePath,   ( 'AAA' + '.pk' )  )
data = pd.read_pickle( fileName  )

fileName = os.path.join( basePath,   ( 'export' + '.pk' )  )
data.to_pickle( fileName  , protocol=4)