Book Image

Data Wrangling with Python 3.x [Video]

By : Jamshaid Sohail
Book Image

Data Wrangling with Python 3.x [Video]

By: Jamshaid Sohail

Overview of this book

You might be working in an organization, or have your own business, where data is being generated continuously (structured or unstructured) and you are looking to develop your skillset so you can jump into the field of Data Science. This hands-on guide shows programmers how to process information. In this course, you will gather data, prepare data for analysis, perform simple statistical analyses, create meaningful data visualizations, and more! This course will equip us with the tools and technologies, also we need to analyze the datasets using Python so that we can confidently jump into the field and enhance our skill set. The best part of this course is the takeaway code templates generated using the real-life dataset. Towards the end of the course, we will build an intuitive understanding of all the aspects available in Python for Data Wrangling. All codes and supporting files are placed on GitHub at this link: https://github.com/PacktPublishing/-Data-Wrangling-with-Python-3.x
Table of Contents (7 chapters)
Chapter 2
Working with Data from Excel and PDF Files
Content Locked
Section 1
Importing and Parsing Excel Files – Part 1
Sometimes organizations/companies find it convenient to store the relevant information about something in sheets of Excel file. We will look into xlrd module to extract information out of Excel file. - Analyze the dataset by manually opening the file - Import the dataset into Python using xlrd module and then print the sheet names and number of sheets - Print the rows of a sheet on the console