Data Acquisition and Manipulation with Python

Acquire and analyse data in different formats with the help of Python data analysis tools

Created by: Packt Publishing
Tech Knowledge in Motion

What Will I Learn?

• See how to acquire and save different formats of data
• Find out how to connect to a database and add information to it
• Combine and merge data sets, and manipulate strings using Python
• Aggregate your data and employ group-wise operations and transformations
• Know how to download and read a web page using the BeautifulSoup package
• Extract useful information from websites using Selenium in Python
• Program and employ a Scrapy spider for successful web scraping

Requirements

• • What will the customer need to install (core software) to follow along? Anaconda, Python, MySQL, Chrome or Firefox
• • What Plugins will the customer need? Install packages as needed
• • What versions of software should the customer use? Relatively recent, but not version sensitive
• • Any special hardware needed? No
• • Can you point to instruction to install anything that we will need to install? (Can be websites, other videos, written instructions) I detail installation in Unpacking NumPy and Pandas, an earlier course. Otherwise, check Chrome/Firefox's site, continuum .io for Anaconda, oracle .com for MySQL
• • Anything that you would like the customers to watch out for like a precautionary measure or a tip? DO NOT SCRAPE THE WEB TOO FAST!!! Also, practice safe web practices.
• • How are the Exercise Files laid out? Code Samples/ Starting State of the Examples/ Finished State of the Examples/ Finished State per video/ Finished State per Chapter/ Finished State per course Exercises are often linked within a section. Many need data files that I have provided. A set of exercises become a guided project that allow viewers to do tasks similar to those shown in the videos. They simply give viewers instructions on what they need to do to complete the exercise.
• • What level user would be best served by this course? For example: "Beginner Django User but Advanced Web Designer"
• • This course has been tested on the following system configuration: ● OS: Windows 10 ● Processor: AMD 64 ● Memory: 12GB ● Hard Disk Space: 300GB ● Video Card: NVidia 560

Target audience

• If you are a budding Data Analyst and you want to learn how to acquire, manage, and manipulate large amounts of data from the web using the Python programming language, then this is the perfect video tutorial for you.