Jul 6Extracting data from tables in PDF [Updated] - PythonThe previous post on Extracting data from tables in PDF was many years old and requires an update as it didn't cover a Python package...
May 24OneMap APIIf you're looking for the latitude and longitude of places in Singapore, you can make use of OneMap API. It is free for public use. Below...
Oct 26, 2020Handling None and NaN in Pandas - PythonThe other day as I was reading in a data from BigQuery into pandas dataframe, I realised the data type for column containing all nulls...
Jun 13, 2020EuroPython 2020 Presentation - AnnouncementFor the latest call for proposals to include other timezones from Asia Pacific and Americas, I decided to submit a talk and am glad that...
Jun 26, 2018Data cleaning - Process - PythonThis post is a replicate of the previous post on R but using Python this time round. However, note that there is a difference in data...
Jun 16, 2018Data cleaning - Process - RData cleaning is one of the most important tasks in data science but it is unglamorous, underappreciated and under-discussed. These are...
Jan 30, 2018Data preparation for scraped data - Process - ExcelThis is Part II of a four-part post. Part I talks about scraping data from a website (bookdepository.com, in this case) while Part II...