# ConsoleFlare ## ConsoleFlare - [Python Installation](https://docs.consoleflare.com/python/python-installation.md): Installation guide - [Pandas and SQL](https://docs.consoleflare.com/python/pandas-and-sql.md) - [Data Analytics Project](https://docs.consoleflare.com/projects/data-analytics-project.md) - [Courier Analytics Challenge](https://docs.consoleflare.com/projects/data-analytics-project/courier-analytics-challenge.md) - [Solution](https://docs.consoleflare.com/projects/data-analytics-project/solution.md) - [Skytrax Airline Review Analysis Pipeline](https://docs.consoleflare.com/projects/skytrax-airline-review-analysis-pipeline.md) - [Setting up Azure SQL Database](https://docs.consoleflare.com/projects/skytrax-airline-review-analysis-pipeline/setting-up-azure-sql-database.md) - [SkyTrax Web Scraping](https://docs.consoleflare.com/projects/skytrax-airline-review-analysis-pipeline/skytrax-web-scraping.md) - [Power BI](https://docs.consoleflare.com/reporting/powerbi.md): Overview - [Installation](https://docs.consoleflare.com/reporting/powerbi/installation.md) - [Data Sources](https://docs.consoleflare.com/reporting/powerbi/data-sources.md) - [Important Links](https://docs.consoleflare.com/reporting/powerbi/important-links.md): Microsoft learn courses - [Spark vs Hadoop](https://docs.consoleflare.com/pyspark-and-databricks/spark-vs-hadoop.md): In this document we will try to understand why spark is better than hadoop - [Cluster Computing](https://docs.consoleflare.com/pyspark-and-databricks/cluster-computing.md): In this document we will try to understand what is cluster computing - [PySpark](https://docs.consoleflare.com/pyspark-and-databricks/pyspark.md): Introduction - [Databricks Introduction](https://docs.consoleflare.com/pyspark-and-databricks/databricks-introduction.md): In this page we will look at a brief introduction about Databricks - [PySpark in Databricks](https://docs.consoleflare.com/pyspark-and-databricks/pyspark-in-databricks.md): In this tutorial, we will see how we can get started with Databricks - [Reading Data with PySpark](https://docs.consoleflare.com/pyspark-and-databricks/reading-data-with-pyspark.md): In this tutorial we will see how we can read data in PySpark - [PySpark Transformation Methods](https://docs.consoleflare.com/pyspark-and-databricks/pyspark-transformation-methods.md): In this tutorial, we will try to explore some of the common data transformation methods in PySpark - [Handling Duplicate Data](https://docs.consoleflare.com/pyspark-and-databricks/handling-duplicate-data.md): In this tutorial, we will see some common methods for how we can handle duplicate data. - [PySpark Action Methods](https://docs.consoleflare.com/pyspark-and-databricks/pyspark-action-methods.md): In this tutorial we will try to look at some of the common action methods in PySpark - [PySpark Native Functions](https://docs.consoleflare.com/pyspark-and-databricks/pyspark-native-functions.md): In this tutorial we will explore some common PySpark native functions - [Partitioning](https://docs.consoleflare.com/pyspark-and-databricks/partitioning.md): In this tutorial we will learn about Partitioning strategy in PySpark - [Bucketing](https://docs.consoleflare.com/pyspark-and-databricks/bucketing.md): In this tutorial we learn about Bucketing strategy in PySpark - [Partitioning vs Bucketing](https://docs.consoleflare.com/pyspark-and-databricks/partitioning-vs-bucketing.md): In this tutorial we will try to understand the difference between Partitioning and Bucketing - [Spark Streaming](https://docs.consoleflare.com/live-data-streaming/master.md): A to-the-point Instruction/Guide for any Spark enthusiast - [Installation Issues](https://docs.consoleflare.com/live-data-streaming/master/installation-issues.md): This page addresses some common errors and issues that you might have while installing Spark on your system. - [Jupyter Notebook Setup](https://docs.consoleflare.com/live-data-streaming/master/jupyter-notebook-setup.md): In this guide you will see how to setup jupyter notebook as a default editor for PySpark - [Azure Data Factory](https://docs.consoleflare.com/data-pipeline/azure-data-factory.md) - [Smart Contract Guide](https://docs.consoleflare.com/blockchain/smart-contract-guide.md): A simple guide for developing and deploying smart-contracts for Blockchain Beginners inspired by the OpenZeppelin Guide - [Setting up a Node project](https://docs.consoleflare.com/blockchain/smart-contract-guide/setting-up-a-node-project.md): Setting up a Node project for smart-contracts - [Developing smart contracts](https://docs.consoleflare.com/blockchain/smart-contract-guide/developing-smart-contracts.md): This guide will let you get started writing Solidity contracts - [SQL Interview Questions](https://docs.consoleflare.com/interview-questions/sql-interview-questions.md): In this document, you can find the list of some commonly asked SQL interview questions. - [Power BI Interview Questions](https://docs.consoleflare.com/interview-questions/power-bi-interview-questions.md): This document will try to highlight some of the most common interview questions asked in Power BI - [Exercise 0](https://docs.consoleflare.com/t-sql-exercises/exercise-0.md): Function in SQL - [Exercise 1](https://docs.consoleflare.com/t-sql-exercises/exercise-1.md) - [Exercise 2](https://docs.consoleflare.com/t-sql-exercises/exercise-2.md) - [Exercise 3](https://docs.consoleflare.com/t-sql-exercises/exercise-3.md) - [Ultimate SQL Server Cheat Sheet](https://docs.consoleflare.com/cheat-sheet/ultimate-sql-server-cheat-sheet.md): This ultimate SQL Server cheat sheet is designed to be a quick reference guide for database administrators, developers, and data analysts. It covers fundamental commands, concepts, and best-practices. --- # 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, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on a page URL with the `ask` query parameter: ``` GET https://docs.consoleflare.com/python/python-installation.md?ask= ``` The question should be specific, self-contained, and written in natural language. 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.