We can analyze marketing productivity, keywords, searched data, tables, information by google, e.g. on wikipedia, audience, marketing text, URL structure, SEO, social, SEM, jsons, structured entities, facebook, text ads. Advertools python package is in 2021 an ideal choice, which can be included into corporate web analytics. %config InlineBackend.figure_format = 'retina'
import matplotlib.pyplot as plt
# install advertools package
pip install advertools
import advertools as adv
import pandas as pd
pd.set_option('display.max_columns', None)
# use google login
cx = 'YOUR_GOOGLE_CUSTOM_SEARCH_ENGINE_ID'
key = 'YOUR_GOOGLE_DEVELOPER_KEY'
# create data frames from wikipedia list and concatenate text information to sentences
top_US_banks = pd.read_html('https://en.wikipedia.org/wiki/List_of_banks_in_the_Americas', header=0)[0]
top_US_banks.head()
names = top_US_banks['Bank name'].tolist()
top_US_banks
names = top_US_banks['Bank name'].tolist()
names
assets= top_US_banks['Total assets (billions of US$)'].tolist()
combined_values = 'Assets of ' + top_US_banks['Bank name'].map(str) + ' are ' + top_US_banks['Total assets (billions of US$)'].map(str)+ '.'
combined_values
0 Assets of JPMorgan Chase & Co. are $2,622.53. 1 Assets of Bank of America are $2,354.51. 2 Assets of Citigroup Inc. are $1,917.38. 3 Assets of Wells Fargo & Co. are $1,895.88. 4 Assets of Royal Bank of Canada are $1,039.24. 5 Assets of Toronto-Dominion Bank are $1,006.00. 6 Assets of Goldman Sachs are $931.80. 7 Assets of Morgan Stanley are $853.53. 8 Assets of Scotiabank are $785.44. 9 Assets of Bank of Montreal are $613.56. 10 Assets of Canadian Imperial Bank of Commerce a... 11 Assets of U.S. Bancorp are $467.37. 12 Assets of Truist Financial are $441.24. 13 Assets of Banco Itaú are $401.10. 14 Assets of PNC Financial Services are $382.32.
dtype: object
Resources: https://buildmedia.readthedocs.org/media/pdf/advertools/master/advertools.pdf https://advertools.readthedocs.io/en/master/ https://adver.tools/ https://www.semrush.com/blog/analyzing-search-engine-results-pages/ https://pypi.org/project/advertools/ https://www.holisticseo.digital/python-seo/perform-text-analysis/ https://python.plainenglish.io/automating-facebook-posts-with-python-using-selenium-7a7ffca0f325
https://rrighart.github.io/GA/ https://thecleverprogrammer.com/2021/04/27/google-search-analysis-with-python/ https://www.honchosearch.com/blog/seo/how-to-use-python-pytrends-to-automate-google-trends-data/ https://medium.com/@mmas/simple-web-analytics-with-python-and-pandas-1e890cbeebe0 https://www.semrush.com/blog/analyzing-search-engine-results-pages/
Comments