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
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...
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
SGproperties | Simply Python
https://simply-python.com/tag/sgproperties
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
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...
SOCIAL ENGAGEMENT