<jupyter_start><jupyter_text>Follow these instructions to get a Google API Key https://developers.google.com/sheets/api/guides/authorizingAPIKey<jupyter_code>api_key = 'FIX ME: Use a valid Google API Key'
service = build('sheets', 'v4', developerKey=api_key)

# Call the Sheets API
sheet = service.spreadsheets()
result = sheet.values().get(spreadsheetId=SAMPLE_SPREADSHEET_ID,
                            range=SAMPLE_RANGE_NAME).execute()
values = result.get('values', [])

df=pd.DataFrame(values[1:])
df.head()<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.1289134438305709, 'fraction_numerical': 0.003683241252302026, 'mean_word_length': 5.252873563218391, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 1, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '1', 'dir': 'jupyter-structured-clean-dedup', 'id': '232587', 'license': 'MIT', 'n_tokens_mistral': 187, 'n_tokens_neox': 184, 'n_words': 35, 'path': 'notebooks/lisdCovid19Dashboard.ipynb', 'repo_name': 'Baelfur/lisdcovidanalysis', 'size': '543'}