I/O Classes

ExcelWriter

Class for writing DataFrame objects to Excel sheets.

import pandasCore as pd

# Write multiple DataFrames to different sheets
with pd.ExcelWriter('output.xlsx') as writer:
    df1.to_excel(writer, sheet_name='Sheet1')
    df2.to_excel(writer, sheet_name='Sheet2')

Parameters

Parameter	Type	Default	Description
path	str	required	Path to Excel file
engine	str	None	Write engine (‘openpyxl’, ‘xlsxwriter’)
date_format	str	None	Format for date columns
datetime_format	str	None	Format for datetime columns
mode	str	‘w’	Write mode (‘w’ or ‘a’)
if_sheet_exists	str	None	Action if sheet exists

Methods

Method	Description
close()	Close and save the file
save()	Alias for close

ExcelFile

Class for parsing tabular Excel sheets into DataFrame objects.

import pandasCore as pd

# Read multiple sheets
xlsx = pd.ExcelFile('data.xlsx')
print(xlsx.sheet_names)  # ['Sheet1', 'Sheet2']
df1 = xlsx.parse('Sheet1')
df2 = xlsx.parse('Sheet2')

Parameters

Parameter	Type	Default	Description
path	str	required	Path to Excel file
engine	str	None	Parser engine

Methods

Method	Description
parse(sheet_name, …)	Parse sheet to DataFrame
close()	Close the file

Attributes

Attribute	Description
sheet_names	List of sheet names
book	Workbook object

HDFStore

Dict-like interface for storing pandas objects in HDF5 format.

import pandasCore as pd

# Write to HDF5
store = pd.HDFStore('data.h5')
store['df'] = df
store.close()

# Read from HDF5
store = pd.HDFStore('data.h5', mode='r')
df = store['df']
store.close()

Parameters

Parameter	Type	Default	Description
path	str	required	Path to HDF5 file
mode	str	‘a’	File mode (‘r’, ‘w’, ‘a’)
complevel	int	None	Compression level (0-9)
complib	str	None	Compression library

Methods

Method	Description
put(key, value, …)	Store object
get(key)	Retrieve object
remove(key)	Remove object
keys()	List of stored keys
items()	Key/value pairs
close()	Close the store
flush()	Flush changes