Workshop 2: Preparing and Exploring Your Data in Python (9 hrs) (2018年5月25-26日)
a. Preparing (pre-processing) your data for growth (3 hrs)
- Know your sources: interviews, field studies, open data, API, websites, IoT, and digital archives
- ETL (extraction, transformation, and loading) in CSV, XML, and JSON formats for data preparation
- Finding a home for your data - cloud computing and its infrastructure for growth and support
- Popular tools for data preparation (e.g. Knime, Open Refine, Google Sheet/Xpath, Scrapinghub, Beautiful Soap, and Scrapy)
日期及時間: 2018年5月25日 (星期五) 晚上6時30分至9時30分
b. Exploring your data in Python (6 hrs)
- Using Anaconda Jupyter Notebook for data exploration in Python
- Introduction to Python operations (operator and operand), control structure, data structure, and function
- Useful Python modules for data exploration, analysis and mining (Mathpotlib, Numpy, Pandas, etc.)
- Free online resources for self-paced learning in Python (codeacademy.com, coursera.org, udacity.com, cognitiveclass.ai, etc.)
日期及時間: 2018年5月26日 (星期六) 上午10時至下午1時 & 下午2時30分至5時30分
|
Workshop 3: Visualizing and Publishing Your Data in Python (9 hrs) (暫定於9月中至10月初進行)
a. Growing your data in the cloud: From Google Sheet to Airtable (3 hrs)
- Beyond Google Sheet — Building relational database in Airtable for storing and managing your data
- The power of views — Displaying and filtering data in form, grid, calendar, kanban, and gallery views
- Functions and API for more advanced data modelling and application development
- Integration with other web applications for team collaboration and project management
b. Data Visualisation in JavaScript (3 hrs)
- Front-end vs. back-end programming: interface with the user and interface with the data using the Python Flask framework
- Useful JavaScript libraries (jQuery, D3, Mpld3, Leaflet, etc.) for data visualization and front-end interactions
- Create your first interactive chart in Matpotlib and Mpld3
- Create your first interactive map in Leaflet
c. Publishing Your Project on the Web (3 hrs)
- The elements of user experience in web design
- The narrative components in user journey within a web design
- Combining Airtable and Bootstrap library for web publishing
- Use of Google Optimize and Google Analytics to track your web project
|