JLJULIENLEONARD.WORDPRESS.COM

simply-python.com

Scraping housing prices using Python Scrapy Part 2 | Simply Python

https://simply-python.com/2016/12/12/scraping-housing-prices-using-python-scrapy-part-2

Programming, Python, Automation. Scraping housing prices using Python Scrapy Part 2. This is the continuation of the previous post on “ Scraping housing prices using Python Scrapy. 8220; In this session, we will use Xpath to retrieve the corresponding fields from the targeted website instead of just having the full html page. For a preview on how to extract the information from a particular web page, you can refer to the following post “ Retrieving stock news and Ex-date from SGX using python. Once verif...

simply-python.com

Manage and extract data using python and Excel tables | Simply Python

https://simply-python.com/2014/08/20/manage-and-extract-data-using-python-and-excel-tables

Programming, Python, Automation. Manage and extract data using python and Excel tables. The script below will utilize the Excel tables to extract various information such as setting files, parameters values and at the same time maintain a neat way of viewing and changing all the parameters. The script will required pyExcel. Which is interface module between python and excel. The concept is to retrieve all the tables and rows specified within the start and closing tag. Is available in GitHub. Wonder where...

simply-python.com

Automating Google Sheets with Python | Simply Python

https://simply-python.com/2016/12/06/linking-google-sheets-with-python

Programming, Python, Automation. Automating Google Sheets with Python. This post demonstrate basic use of python to read/edit Google sheets. For fast setup, you can visit this link. Below is the setup procedure copied from the link itself. To create or select a project in the Google Developers Console and automatically turn on the API. Click Continue, then Go to credentials. On the Add credentials to your project page, click the Cancel button. Click OK to dismiss the resulting dialog. You can easily acce...

simply-python.com

Retrieving stock news and Ex-date from SGX using python | Simply Python

https://simply-python.com/2015/04/15/retrieving-stock-news-and-ex-date-from-sgx-using-python

Programming, Python, Automation. Retrieving stock news and Ex-date from SGX using python. For Singapore stocks, one of the way to retrieve the latest company news and announcements (such as trading halt, general announcements, dividend info) are through the Singapore Exchange (SGX) main webpage. Besides company announcements, the following are the list of data that can be retrieved:. Latest price (also some of parameters based on SGX stock filters). To retrieve the stocks announcements or news. The page ...

simply-python.com

automation | Simply Python

https://simply-python.com/tag/automation

Programming, Python, Automation. Automating Google Sheets with Python. This post demonstrate basic use of python to read/edit Google sheets. For fast setup, you can visit this link. Below is the setup procedure copied from the link itself. To create or select a project in the Google Developers Console and automatically turn on the API. Click Continue, then Go to credentials. On the Add credentials to your project page, click the Cancel button. Click OK to dismiss the resulting dialog. You can easily acce...

simply-python.com

Scraping housing prices using Python Scrapy | Simply Python

https://simply-python.com/2016/11/25/scraping-housing-prices-using-python-scrapy

Programming, Python, Automation. Scraping housing prices using Python Scrapy. This post (and subsequent posts) show how to scrape the latest housing prices from the web using python Scrapy. As an example, the following website, propertyguru.com. For a guide of running Scrapy, you can refer to the Scrapy tutorial. The following guidelines can be used for building a simple project. Scrapy startproject name of project. Define items in items.py (temporary set a few fields). Market=residential&property type c...

publichealthintelligence.org

Data and Visualization sites | Health Intelligence

http://www.publichealthintelligence.org/content/resources/data-and-visualization-sites

Skip directly to content. Analyzing health data, generating and communicating evidence to improve population health. Reading for Data Visualizations. Best of the Viz Web. Reading for Health Analysis. Online Courses and Training. Global Peace Index 2008-2016. Are You Really Tall? Planetary Health: addressing major public health threats caused by human impacts on the natural world. Trends in Maternal Mortality: selected countries from 1980 to 2013. Causes of Maternal Mortality from 1980 to 2013. DensityDes...

simply-python.com

HDB resale prices | Simply Python

https://simply-python.com/tag/hdb-resale-prices

Programming, Python, Automation. Scraping housing prices using Python Scrapy Part 2. This is the continuation of the previous post on “ Scraping housing prices using Python Scrapy. 8220; In this session, we will use Xpath to retrieve the corresponding fields from the targeted website instead of just having the full html page. For a preview on how to extract the information from a particular web page, you can refer to the following post “ Retrieving stock news and Ex-date from SGX using python. Once verif...

simply-python.com

Rapid generation of powerpoint report with template scanning | Simply Python

https://simply-python.com/2014/07/04/rapid-generation-of-powerpoint-report-with-template-scanning

Programming, Python, Automation. Rapid generation of powerpoint report with template scanning. In my work, I need to create PowerPoint (ppt) report of similar template. For the report, I need to create various plots in Excel or JMP, save it to folders and finally paste them to ppt. It be great if it is possible to generate ppt report rapidly by using automation. I have created a python interface to powerpoint. Using com commands hoping it will help to generate the report automatically. The script will th...