Highlights
- Learn core concepts of the Python environment, language & data science.
- Use Python to get your Excel and SQL data in shape, and take advantage of its features and techniques to gain actionable Insights
- Explore Python data science tools such as NumPy and Pandas
- Explore the opportunity to apply the proposed concepts on real data science applications
- Acquire knowledge on how to access and clean/prepare data
- Use data analysis to perform the computation of summary information and basic statistics
- Use effective data visualisation techniques to help you with complex data structures
Python for Data Analysts & Quants training:
- Master Data Analysis with Python: Learn the fundamentals of data analysis using Python, gaining proficiency in data manipulation, cleaning, and visualization with popular libraries like Pandas
- Quantitative Finance Techniques: Dive into quantitative finance methodologies, exploring statistical models, time series analysis, and risk management strategies essential for financial data interpretation.
-
Real-world Applications: Apply Python to solve real-world financial problems and make data-driven decisions, with hands-on projects covering portfolio optimization, asset pricing, and risk assessment.
Course Details
Environment Set-up
• The Anaconda distribution as Python Data Science platform
• Overview on Python virtual environment set-up
• Running Python code in Jupyter notebook
Python core concepts
• Built-in data types in Python
• Working with strings, numbers, lists, tuples and dictionaries
• Control flow statements
• Conditional execution with if statements
• Conditional loops with where statements
• Looping over a sequence with for statements
• Defining and using custom functions
• Working with dates and times
• Accessing data on file (CSV, JSON, ...)
Python Data Science libraries
• Working with data in pandas
- Working with table-like data in pandas
- Creating Series and DataFrame objects
- Loading data from file into DataFrame objects
- Adding, removing and updating databases
Retrieving data in pandas
- Querying data to extract specific rows and columns
- Filtering data on specific conditions
- Understanding pandas indexing
Data manipulation in pandas
- Data transformation
- Applying functions to transform individual values
- Applying functions to aggregate values by rows and columns
- Data Transformation for Python for Data Analysts & Quants.
Missing data in pandas
- Identifying missing data points
- Filtering out missing data
- Filling missing data with given values, interpolation and other filling strategies
Data Analysis in pandas
- Extracting summary statistics over DataFrame objects
- Performing data aggregation queries (groupby() method)
- Aggregating multiple columns in the same query
- Exploratory analysis of new datasets
Data Visualisation in pandas
- Plotting data from a Series or DataFrame object
- Bar plots, line plots, scatter plots, histograms and other common charts
- Basic customisation of charts
Working with multiple tables
- Concatenation of multiple tables based on structure/schema
- Join/merge operations with DataFrame objects based on values
- Reindexing operations, dealing with duplicate labels in the index
- Dealing with duplicate records
- Renaming columns
Time Series with pandas
- Working with date and time data types in pandas
- Creating ranges of date/time data points
- Indexing by time
- Resampling: data aggregation over time
- Moving window operations, e.g. moving average
- Defining custom calendars, custom business days, custom holidays
Working with text data in DataFrames
- Using the str attribute in pandas objects
- String manipulation functions in pandas
- Filtering data with string pattern matching
SQL databases
- Connecting to SQL databases with SQLAlchemy
- Loading data from SQL to pandas
- Sending SQL queries to a database and retrieving the results in Python and pandas
NumPy
- Working with multi-dimensional arrays with NumPy
- Arithmetic operations with NumPy arrays
- Vectorised operations with NumPy arrays
- Stats and linear algebra with NumPy
- Slicing and indexing NumPy arrays
Data Visualisation
- Overview on the basic types of charts available with the Python libraries
- Bar plots, line plots, histograms, scatter plots, pie charts
- Customising the layout and format of a chart
- Examples of static visualisation with matplotlib
- Examples of interactive visualisation with plotly
Who should attend
- Finance and Investment Analysts
- Data Scientists and Analysts
- Financial Planners and Advisors
- Graduates and Students in Finance
- Business Professionals in Finance
- Experienced Python developers
Feedback
4.8 out of 5 average
"I hadn't integrated Pandas with Python before joining my company. So it's very useful to consolidate my understanding of such skills via this course." JL, Data Analyst, Python for Data Analytics, March 2021