Python Data Course, Prepare, Clean, Transform Data. In-Classroom/Online.
Schedule
Thu, 02 Apr, 2020 at 11:00 am to Mon, 27 Jan, 2025 at 04:00 pm
Location
PCWorkshops at Regus Near Trafalgar Square | London, EN
About this Event
Python for Data Analysis
Course summaryYou would learn to manipulate large and varied datasets by getting hands-on, practical experience working on real-life data problems.
You would gain working knowledge of the most commonly used Python modules for data scientists.
Get data from data sources, merge and copmbine it to one or more data sets.
Clean your data, re-structure, transform, manipulate data to make sure it is suitable for your use case.
- Location: Online Instructor-led, Or at your office, Or at our classroom.
- To arrange training at your site, contact us.
- For training in our classroom, book a training ticket and a classroom ticket, or contact us to discuss your group size.
- Duration: 1 Day
Course Outline:
Session 1:
Brief Revision of Python Basics.
Session 2: Data Structures
Lists, Tuples, Sets, Dictionaries, List and Dict Comprehensions
Session 3: Data and Files
Reading and writing CSV files into a Python program: The CSV module,Txt Files. Bytes and Unicode with files. Json Files. Exception Handling.
Session 3: Database
Linking with SQL Database, Insert Tables, Insert, Update and delete records. Select queries, traverse and display query results.
Session 3: API's
Inter-acting with Api's
Session 4: Numpy
The Python NumPy Module: Working with arrays, array manipulation, string, math, arithmetic and statistical functions.
Session 5: Pandas
The Python Pandas: Dataframes, Series, Indexing, Sorting, Filter, Slicing, Iteration, Functions, Date/ Time Functionality. Time series.
Session 6: Data Cleaning and preparation
Random Sampling. Finding and filtering data, Replacing values, Finding and filtering Missing data, Remove Duplicates, String objects, Regex. Transforming data using function and mapping, Renaming Axis Indexes, Discretization and Binning.
Session 7: Data Wrangling
Hierarchical Indexing, Reorder, Sorting, Stastitics, Dataframe Joins, Merging, Concatenation, Overlap. Reshaping and pivoting.
Session 7: Scipy
Introduction and overview of SciPy functions.
Session 6: Plotting and Visualization
Introducing to plotting data with MatPlotLib
Where is it happening?
PCWorkshops at Regus Near Trafalgar Square, Golden Cross House, London, United KingdomEvent Location & Nearby Stays:
GBP 185.00 to GBP 300.00
