> For the complete documentation index, see [llms.txt](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics.md).

# Python for Data Analytics

- [1. Python](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python.md)
- [1. Python Documents](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents.md)
- [Python Environment Setup](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/python-environment-setup.md)
- [1. Programming](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/1.-programming.md)
- [2. Data Types](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/2.-data-types.md): In this document you will  understand, the concept of data and and how python has categorized them.
- [3. Variables in Python](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/3.-variables-in-python.md)
- [4. Memory Allocation](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/4.-memory-allocation.md)
- [5. Operators](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/5.-operators.md)
- [Operators Cheatsheet](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/5.-operators/operators-cheatsheet.md): Complete Python operators cheatsheet with clear examples for quick revision
- [6. User Input](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/6.-user-input.md)
- [User Input In Python CheatSheet](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/6.-user-input/user-input-in-python-cheatsheet.md): Complete Python User Input cheatsheet with clear examples for quick revision
- [7. Typecasting](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/7.-typecasting.md)
- [TypeCasting in Python CheatSheet](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/7.-typecasting/typecasting-in-python-cheatsheet.md): Typecasting is converting a value from one data type to another in Python. This is useful when you need to perform operations on different data types.
- [8. Functions : Basics](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/8.-functions-basics.md)
- [Functions Cheatsheet](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/8.-functions-basics/functions-cheatsheet.md): Complete Python Functions cheatsheet with clear examples for quick revision
- [9. String](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/9.-string.md)
- [String CheatSheet](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/9.-string/string-cheatsheet.md): Complete Python String Cheatsheet with clear examples for quick revision
- [11. Conditional Statements](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/11.-conditional-statements.md)
- [Conditionals Cheatsheet](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/11.-conditional-statements/conditionals-cheatsheet.md): Complete Python Conditionals cheatsheet with clear examples for quick revision
- [12. Loops](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/12.-loops.md)
- [Loops Cheatsheet](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/12.-loops/loops-cheatsheet.md): Complete Python Loops cheatsheet with clear examples for quick revision
- [13. List](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/13.-list.md)
- [List Cheatsheet](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/13.-list/list-cheatsheet.md): Complete Python List cheatsheet with clear examples for quick revision
- [14. Set](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/14.-set.md)
- [Sets Cheatsheet](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/14.-set/sets-cheatsheet.md): Complete Python Sets cheatsheet with clear examples for quick revision
- [15. Tuple](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/15.-tuple.md)
- [16. Dictionary](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/16.-dictionary.md)
- [Dictionary Cheatsheet](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/16.-dictionary/dictionary-cheatsheet.md): Complete Python Dictionary cheatsheet with clear examples for quick revision
- [17. Functions: Advance](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/17.-functions-advance.md)
- [18. File Handling](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/18.-file-handling.md)
- [19. OS Module](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/1.-python-documents/19.-os-module.md)
- [2. Python Assignments](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments.md)
- [Data Type & Variables](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/data-type-and-variables.md)
- [Operators Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/operators-assignment.md)
- [User Input & Type Casting](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/user-input-and-type-casting.md)
- [Functions- Basic Assignments](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/functions-basic-assignments.md)
- [String Assignments](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/string-assignments.md)
- [Conditional Statements Assignments](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/conditional-statements-assignments.md)
- [Loops Assignments](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/loops-assignments.md)
- [Loop Assignments](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/loop-assignments.md)
- [List Assignments](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/list-assignments.md)
- [Set Assignments](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/set-assignments.md)
- [Dictionary Assignments](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/dictionary-assignments.md)
- [Function - Advance Assignments](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/2.-python-assignments/function-advance-assignments.md)
- [3. Python Projects](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects.md)
- [Employee Management System](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/employee-management-system.md)
- [Hamming distance](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/hamming-distance.md)
- [Webscraping With Python](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/webscraping-with-python.md)
- [Introduction To Web Scraping](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/webscraping-with-python/introduction-to-web-scraping.md)
- [Importing Necessary Libraries](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/webscraping-with-python/importing-necessary-libraries.md)
- [Basic Introduction To HTML](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/webscraping-with-python/basic-introduction-to-html.md)
- [Introduction To BeautifulSoup](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/webscraping-with-python/introduction-to-beautifulsoup.md)
- [Flipkart Web Scraping](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/webscraping-with-python/flipkart-web-scraping.md)
- [Scraping Step By Step](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/webscraping-with-python/flipkart-web-scraping/scraping-step-by-step.md)
- [Retail Sales Analysis](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/retail-sales-analysis.md)
- [Guess the Word Game](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/guess-the-word-game.md)
- [Data Collection Through APIs](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/data-collection-through-apis.md)
- [To-Do List Manager](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/to-do-list-manager.md)
- [Atm-functionalities(nested if)](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/atm-functionalities-nested-if.md): In this project we will create a program which shows how an atm machine works related to basic functions as show account balance,cash withdraw,cash deposit and pin change.
- [Distribution of Cards(List & Nested for)](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/distribution-of-cards-list-and-nested-for.md): We are going to create a program that will distribute 52 cards of a deck amongst 4 players "Randomly".
- [Guess the Number Game](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/guess-the-number-game.md)
- [Weather Data Analyzer](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/weather-data-analyzer.md)
- [YouTube Comment Analysis Project](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/3.-python-projects/youtube-comment-analysis-project.md): Build a Python program that classifies YouTube comments and reports sentiment statistics.
- [4.Python + SQL Projects](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/4.python-+-sql-projects.md)
- [Bookstore Management System](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/1.-python/4.python-+-sql-projects/bookstore-management-system.md)
- [2. Data Analytics](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics.md)
- [1. Introduction To Numpy](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/1.-introduction-to-numpy.md)
- [2. Numpy operations](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/2.-numpy-operations.md)
- [3. Multidimensional Array in Numpy](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/3.-multidimensional-array-in-numpy.md)
- [1. Introduction to pandas](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/1.-introduction-to-pandas.md)
- [2.Loading Excel and CSV Data](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/2.loading-excel-and-csv-data.md)
- [3.DataFrame and Series](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/3.dataframe-and-series.md)
- [4. Series Operations In Pandas](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/4.-series-operations-in-pandas.md)
- [5. Filtering](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/5.-filtering.md)
- [6. Sorting Value in Pandas](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/6.-sorting-value-in-pandas.md)
- [7. Aggregate Functions](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/7.-aggregate-functions.md)
- [8. Practice - air quality usa vs india](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/8.-practice-air-quality-usa-vs-india.md)
- [9. value\_counts() and groupby()](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/9.-value_counts-and-groupby.md)
- [10. datetime in pandas](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/10.-datetime-in-pandas.md)
- [11. UDF](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/11.-udf.md)
- [12. String Function In Pandas](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/12.-string-function-in-pandas.md)
- [13. validation in pandas](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/13.-validation-in-pandas.md)
- [14. Data Cleaning in Pandas](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/14.-data-cleaning-in-pandas.md)
- [15. Outliers in pandas](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/15.-outliers-in-pandas.md)
- [16. Joining in Pandas](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/16.-joining-in-pandas.md)
- [17. Matplotlib For Data Visualization](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/17.-matplotlib-for-data-visualization.md)
- [18. Seaborn](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/18.-seaborn.md)
- [19. Retail Sales Analysis](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/19.-retail-sales-analysis.md)
- [Retail Sales Step By Step](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/19.-retail-sales-analysis/retail-sales-step-by-step.md)
- [20. E-commerce](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/20.-e-commerce.md)
- [21. Extras](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/21.-extras.md)
- [seab](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/seab.md)
- [17. Matplotlib For Data Visualization...](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/17.-matplotlib-for-data-visualization....md)
- [Introduction to English](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/introduction-to-english.md)
- [18. Seaborn](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/18.-seaborn-1.md)
- [Required Files](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/2.-data-analytics/required-files.md)
- [Seaborn Md](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/seaborn-md.md)
- [3. SQL](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql.md)
- [DBMS and SQL](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/dbms-and-sql.md)
- [Datatypes](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/datatypes.md)
- [Database Creation](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/database-creation.md): we will create our first database and insert data inside our database
- [Database Creation Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/database-creation/database-creation-assignment.md): Practice questions for database creation, tables, SELECT, INSERT, primary keys, and IDENTITY
- [DDL & DML Commands](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/ddl-and-dml-commands.md)
- [DDL & DML Commands](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/ddl-and-dml-commands/ddl-and-dml-commands.md)
- [Importing file in Database](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/importing-file-in-database.md)
- [Operators, Distinct & Sorting](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/operators-distinct-and-sorting.md)
- [Operators, Distinct & Sorting](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/operators-distinct-and-sorting/operators-distinct-and-sorting.md): Beginner-friendly practice questions on operators, DISTINCT, and sorting in SQL Server
- [Group By ,Aggregate Functions & Having Clause](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/group-by-aggregate-functions-and-having-clause.md)
- [Group By, Aggregate Functions & Having Clause](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/group-by-aggregate-functions-and-having-clause/group-by-aggregate-functions-and-having-clause.md)
- [String Functions](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/string-functions.md)
- [String Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/string-functions/string-assignment.md): practice questions on string functions with sample data and answers
- [Date and Time Functions](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/date-and-time-functions.md)
- [Date and Time Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/date-and-time-functions/date-and-time-assignment.md): Beginner-friendly practice questions on date and time functions in SQL Server
- [Truncate and Numeric Functions](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/truncate-and-numeric-functions.md)
- [Truncate and Numeric Functions Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/truncate-and-numeric-functions/truncate-and-numeric-functions-assignment.md): practice questions on TRUNCATE, numeric functions, and data conversion in SQL Server
- [Joins](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/joins.md)
- [Joins Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/joins/joins-assignment.md): Beginner-friendly section-wise JOIN practice questions in SQL Server with sample data and solutions
- [Set Operations](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/set-operations.md)
- [Set Operations Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/set-operations/set-operations-assignment.md): Practice UNION, UNION ALL, INTERSECT, and EXCEPT in SQL Server.
- [Variables & Table Variables](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/variables-and-table-variables.md)
- [Variables & Table Variables Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/variables-and-table-variables/variables-and-table-variables-assignment.md): Practice SQL Server variables and table variables.
- [Views and Triggers](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/views-and-triggers.md)
- [Views and Triggers Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/views-and-triggers/views-and-triggers-assignment.md): Practice SQL Server views and triggers
- [Transactions and Exception Handling](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/transactions-and-exception-handling.md)
- [Transactions and Exception Handling Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/transactions-and-exception-handling/transactions-and-exception-handling-assignment.md)
- [SubQueries](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/subqueries.md)
- [SubQueries Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/subqueries/subqueries-assignment.md): Practice SQL Server subqueries
- [Scalar & Table Valued Functions](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/scalar-and-table-valued-functions.md)
- [Scalar & Table Valued Functions Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/scalar-and-table-valued-functions/scalar-and-table-valued-functions-assignment.md)
- [Constraints](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/constraints.md)
- [Constraints Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/constraints/constraints-assignment.md): Practice SQL Server constraints
- [Window Functions , Moving Average & CTE](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/window-functions-moving-average-and-cte.md)
- [Window Functions, Moving Average & CTE Assignment](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/3.-sql/window-functions-moving-average-and-cte/window-functions-moving-average-and-cte-assignment.md): Practice SQL Server window functions, moving calculations, and CTEs.
- [4. Power BI](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi.md)
- [1. Introduction to Power BI](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/1.-introduction-to-power-bi.md): In this module, all of you will learn about interactive dashboards and reporting
- [2. Loading the Data](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/2.-loading-the-data.md): How to load different types of files in PowerBi
- [3. Power Query Editor](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/3.-power-query-editor.md): In this module we get to know, how we can Clean and Filter our Data
- [4. Report View, Table View and Model View](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/4.-report-view-table-view-and-model-view.md): In this module we know, how many types of reports in Power Bi we can make and check.
- [5. Report Modeling (Report View)](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/5.-report-modeling-report-view.md): In this module we know, how we can enhance over Power BI report with the help of different type of modules.
- [6. Drill Through, Tooltips,  and Edit Interaction](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/6.-drill-through-tooltips-and-edit-interaction.md): In this module, we learn how we can create Drill Through, Tooltips,  and Edit Interaction with Power BI Reports.
- [7. Customize Tooltip in Power BI](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/7.-customize-tooltip-in-power-bi.md): In this module, we learn how we can create Customize Tooltip in Power BI Reports.
- [8. Introduction to DAX](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/8.-introduction-to-dax.md): In this module, we get to know how we can work on formulas over the Power BI Reports.
- [9. Measures & Calculated Tables In Power BI Report](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/9.-measures-and-calculated-tables-in-power-bi-report.md): In this module, we learn how we can create Measures & Calculated Tables in Power BI Reports.
- [10. Bookmarks In Power BI](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/10.-bookmarks-in-power-bi.md): In this module, we learn how we can create Bookmarks in Power BI Reports.
- [11. Bookmark In Charts Visual](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/11.-bookmark-in-charts-visual.md): In this module, we learn how we can create Bookmark In Charts Visual in Power BI Reports.
- [12. Hamburger Menu in Power BI Report](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/12.-hamburger-menu-in-power-bi-report.md): In this module, we learn how we can create Hamburger Menu in Power BI Reports.
- [13. Dynamic Title](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/13.-dynamic-title.md)
- [13. Power BI Service](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/13.-power-bi-service.md): How to load
- [14. Row Level Security](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/4.-power-bi/14.-row-level-security.md)
- [Agentic AI](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai.md)
- [1.  Introduction To Agentic AI](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai/1.-introduction-to-agentic-ai.md): Learn what Agentic AI is, how it works, and where to use it.
- [2. Set Up LangChain in PyCharm](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai/2.-set-up-langchain-in-pycharm.md): Learn how to set up a LangChain development environment in PyCharm by creating a project, installing dependencies, configuring API keys, and running your first AI model.
- [3. LangChain Fundamentals: Chat Models](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai/3.-langchain-fundamentals-chat-models.md): Discover how Chat Models send prompts to AI models and return responses, making it easy to switch between different LLM providers with minimal code changes.
- [4. LangChain Fundamentals: Prompt Templates](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai/4.-langchain-fundamentals-prompt-templates.md): Learn how Prompt Templates help AI agents create dynamic, reusable prompts, making your LangChain applications cleaner, more consistent, and easier to maintain.
- [5. LangChain Fundamentals: Chains (LCEL)](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai/5.-langchain-fundamentals-chains-lcel.md): Learn how LangChain Chains (LCEL) connect Prompt Templates, Chat Models, and Output Parsers into reusable workflows for building AI agents.
- [6. Build Your First AI Document Summarizer with LangChain](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai/6.-build-your-first-ai-document-summarizer-with-langchain.md): Learn how to load a PDF, extract its content, create reusable prompts, and prepare an AI-powered document summarizer using LangChain.
- [7. Running the Document Summarization Chain](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai/7.-running-the-document-summarization-chain.md): Learn how to connect PromptTemplate and Chat Models using LCEL, execute the workflow with invoke(), and generate structured summaries from PDF documents.
- [8.  Build a Real AI Job Search Agent with LangChain - \[ Full Code \]](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai/8.-build-a-real-ai-job-search-agent-with-langchain-full-code.md)
- [9.  Tool Calling in LangChain - Building Custom Tools](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai/9.-tool-calling-in-langchain-building-custom-tools.md)
- [10. Tool Binding and the Agent Loop in LangChain](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai/10.-tool-binding-and-the-agent-loop-in-langchain.md)
- [11.  ReAct Pattern - Build an AI Agent Without Function Calling](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/agentic-ai/11.-react-pattern-build-an-ai-agent-without-function-calling.md)
- [Statistics](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/statistics.md)
- [Pyspark Notes](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/pyspark-notes.md)
- [Microsoft Fabric](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/microsoft-fabric.md)
- [One Platform Solution](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/microsoft-fabric/one-platform-solution.md)
- [Warehouse VS Lakehouse](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/microsoft-fabric/warehouse-vs-lakehouse.md)
- [Microsoft Copilot for Fabric](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/microsoft-fabric/microsoft-copilot-for-fabric.md)
- [Last Page](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/microsoft-fabric/last-page.md)
- [Introduction to Microsoft Fabric](https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics/microsoft-fabric/introduction-to-microsoft-fabric.md)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://consoleflare-1.gitbook.io/data-analytics-and-data-science-assignments/python-for-data-analytics.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.