semantic_keyword_research_2.py

term = input('What keyword would you like to explore?')
df1 = pd.DataFrame(parse_response(requests.get(build_seo_urls(phrase=term)).content))

try:
    keyword_list = secondary_layer(crawl_urls=df1['Url'])
except KeyError as e:
    raise Exception("The keyword you have inputted is either not in SEMrush's database or your input was incorrectly submitted. Please rerun and try again.")
    
third_layer = third_layer_setup(second_layer_kw=keyword_list)
third_layer = third_layer.merge(keyword_list[['Keyword','Search Volume', 'CPC', 'Competition']], on="Keyword", how='left')
third_layer = third_layer.sort_values(by='Occurance', ascending=False)
third_layer.drop_duplicates(inplace=True)
third_layer = third_layer.reset_index(drop=True)
third_layer = third_layer[['Keyword', 'Search Volume', 'CPC', 'Competition', 'Occurance']]
third_layer['Competition'] = third_layer['Competition'].astype(float)

# Document how many keywords were found
print(f'There were {third_layer.shape[0]} relevant keywords collected.')
third_layer.to_csv(f'{term}.csv', index=False)