# Reading a Single Worksheet from an Excel File

import pandas as pd

df = pd.read_excel('sample.xlsx', sheet_name='Sheet1')
print(df)

# Writing to a Single Worksheet in an Excel File
import pandas as pd

data = {
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Age': [25, 30, 35],
    'City': ['New York', 'Los Angeles', 'Chicago']
}
df = pd.DataFrame(data)
df.to_excel('output.xlsx', index=False, sheet_name='Sheet1')

# Reading Multiple Worksheets from an Excel File
import pandas as pd

xls = pd.ExcelFile('sample.xlsx')
print(xls.sheet_names)
df1 = pd.read_excel(xls, sheet_name='Sheet1')
df2 = pd.read_excel(xls, sheet_name='Sheet2')
print(df1)
print(df2)

# Writing Multiple DataFrames to Multiple Worksheets in an Excel File
import pandas as pd

data1 = {
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Age': [25, 30, 35]
}
data2 = {
    'City': ['New York', 'Los Angeles', 'Chicago'],
    'Population': [8000000, 4000000, 2700000]
}
df1 = pd.DataFrame(data1)
df2 = pd.DataFrame(data2)
with pd.ExcelWriter('output.xlsx') as writer:
    df1.to_excel(writer, sheet_name='Sheet1', index=False)
    df2.to_excel(writer, sheet_name='Sheet2', index=False)

# Reading an Excel File with Double Quotes in Fields
import pandas as pd

df = pd.read_excel('sample_with_quotes.xlsx', quotechar='"')
print(df)

# Writing an Excel File with Double Quotes in Fields
import pandas as pd

data = {
    'Name': ['Alice', 'Bob', 'Charlie'],
    'Quote': ['"one, two, three"', '"four, five, six"', '"10,20,30"']
}
df = pd.DataFrame(data)
df.to_excel('output_with_quotes.xlsx', index=False, quotechar='"', quoting=1)