Stone River eLearning – Data Analysis with Python and Pandas

Python programmers are some of the most sought-after employees in the tech world, and Python itself is fast becoming one of the most popular programming languages. One of the best applications of Python however is data analysis; which also happens to be something that employers can’t get enough of. Gaining skills in one or the other is a guaranteed way to boost your employability – but put the two together and you’ll be unstoppable!

Become and expert data analyser

• Learn efficient python data analysis
• Manipulate data sets quickly and easily
• Master python data mining
• Gain a skillset in Python that can be used for various other applications

Python data analytics made Simple

This course contains 51 lectures and 6 hours of content, specially created for those with an interest in data analysis, programming, or the Python programming language. Once you have Python installed and are familiar with the language, you’ll be all set to go.

The course begins with covering the fundamentals of Pandas (the library of data structures you’ll be using) before delving into the most important functions you’ll need for data analysis; creating and navigating data frames, indexing, visualising, and so on. Next, you’ll get into the more intricate operations run in conjunction with Pandas including data manipulation, logical categorising, statistical functions and applications, and more. Missing data, combining data, working with databases, and advanced operations like resampling, correlation, mapping and buffering will also be covered.

By the end of this course, you’ll have not only have grasped the fundamental concepts of data analysis, but through using Python to analyse and manipulate your data, you’ll have gained a highly specific and much in demand skill set that you can put to a variety of practical used for just about any business in the world.

Tools Used

Python: Python is a general purpose programming language with a focus on readability and concise code, making it a great language for new coders to learn. Learning Python gives a solid foundation for learning more advanced coding languages, and allows for a wide variety of applications.

Pandas: Pandas is a free, open source library that provides high-performance, easy to use data structures and data analysis tools for Python; specifically, numerical tables and time series. If your project involves lots of numerical data, Pandas is for you.

NumPy: Like Pandas, NumPy is another library of high level mathematical functions. The difference with NumPy however is that was specifically created as an extension to the Python programming language, intended to support large multi-dimensional arrays and matrices.

• Section introduction (0:48)
• Creating and Navigating a Dataframe (8:34)
• Slices, head and tail (7:59)
• Indexing (7:27)
• Visualizing The Data (9:19)
• Converting To Python List Or Pandas Series (4:15)
• Section Conclusion (1:38)

• Section introduction (2:12)
• Read Csv And To Csv (9:26)
• io operations (5:23)
• Read_hdf and to_hdf (8:25)
• Read Json And To Json (9:54)
• Read Pickle And To Pickle (11:41)
• Section Conclusion (3:52)

• Section introduction (2:04)
• Column Manipulation (Operatings on columns, creating new ones) (7:27)
• Column and Dataframe logical categorization (7:12)
• Statistical Functions Against Data (7:34)
• Moving and rolling statistics (10:00)
• Rolling apply (8:54)
• Section Outro (3:17)

• Section Intro (3:13)
• drop na (6:48)
• Filling Forward And Backward Na (11:09)
• detecting outliers (12:38)
• Section Conclusion (5:17)

• Section Introduction (3:53)
• Concatenation (9:17)
• Appending data frames (7:06)
• Merging dataframes (9:43)
• Joining dataframes (9:40)
• Section Conclusion (4:29)

• Section Introduction (2:48)
• Basic Sorting (8:56)
• Sorting by multiple rules (8:34)
• Resampling basics time and how (mean, sum etc) (10:03)
• Resampling to ohlc (7:12)
• Correlation and Covariance Part 1 (10:03)
• Correlation and Covariance Part 2 (11:56)
• Mapping custom functions (9:23)
• Graphing percent change of income groups (7:23)
• Buffering basics (10:12)
• Buffering Into And Out Of Hdf5 (10:03)
• Section Conclusion (3:00)

• Section Introduction (1:00)
• Writing to reading from database into a data frame (10:24)
• Resampling data and preparing graph (7:54)
• Finishing Manipulation And Graph (9:32)
• Section and course Conclusion (5:27)