import pandas as pd

# Read only the desired sheet
df = pd.read_excel('mmc2.xlsx', sheet_name='Autosomal')

# Select the two columns
subset = df[['gene', 'qval_dnccPTV']]

# Rename the second column
subset = subset.rename(columns={'qval_dnccPTV': 'Satterstrom Buxbaum Cell 2020 qval'})


# Write to CSV
subset.to_csv('Satterstrom_Buxbaum_Cell_2020_autosomal_qvalue.csv', index=False)