Month: June 2020

Expanded Topic Search that identifies various resources for working with Excel workbook using Python and Pandas

Here is an Expanded Topic Search that identifies various resources for working with Excel workbook using Python and Pandas

This report is in response to a current series of questions about how to use Python to work with Excel workbooks.

Some of this resources are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Excel In Python Search_String_CountsDownload

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Excel In Python Direct_URLsDownload

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

Google Suggestins Excel In PythonDownload

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Excel In PythonDownload

Expanded Topic Search that identifies various resources for Creating Research Projects for High School Students.

I believe that this Topic Search Process could provide High School Students a running start at the beginning of their research studies.

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Research Search_String_CountsDownload

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Research Direct_URLsDownload

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

Google Suggestion for Research ProjectsDownload

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

ResearchDownload

Expanded Topic Search for NotePad ++

Here is an Expanded Topic Search that identifies various resources for NotePad ++

Some are well known and some are not so well known.

My topic search report begins with a list of search strings which are passed individually to Google Search.

The resulting Google source page is captured and parsed for each search string.

There are three sub reports that are extracted from the Google source page:

  1. Landing page for each discovered URL
  2. Title for each discovered URL
  3. List of Google suggested search terms

Once the list of search terms has been processed, then a secondary process is executed to aggregate the collection of sub reports that were generated for each of the input search terms.

Collection of URLs – landing pages listed by the number of occurrences for the individual search strings. Scanning this list of landing pages can bring to light new resources. Note that since this is PDF document – each URL is a hyperlink. Some of the links listed in the search string count PDF may not function because I have prefixed “www.” to the landing URL. This prefix may need to be removed.

Notepad Plus Plus Search_String_CountsDownload

Collection of Direct URLs – details of each discovered URL, giving its title and identifying the search string that returned the URL. Again, note this is a PDF document hence the URLs are hyperlinks. Double click and your browser will open to the web page.

Notepad Plus Plus Direct_URLsDownload

Collection of Google Suggested Search Terms – note that the reports presented here made use of this feature to expand the original search!

Google Suggestions for Notepad Plus PlusDownload

The workbook that was the source of the other reports is included here in case the user would like to generate focused reports.

Notepad Plus PlusDownload