# Pythonspot Documentation & Tutorials

> Pythonspot is a practical programming reference site with tutorials on Python programming, desktop GUI development (PyQt5, Tkinter), data analysis (Pandas), data visualization (Matplotlib), relational databases (SQLite, PostgreSQL, MySQL, SQLAlchemy), web development (Flask, Django), and machine learning. Every tutorial has a matching browser based tool for practising it.

## Practice Tools
Three browser based tools, linked from every relevant tutorial.
- [Practice tools overview](https://pythonspot.com/practice/): which tool to use for which tutorial.
- [PyChallenge](https://pychallenge.com/): graded Python exercises in the browser covering loops, strings, functions, classes, files, Flask, Pandas and Matplotlib. It reports why a wrong answer is wrong, and there is nothing to install.
- [SQLCrab](https://sqlcrab.com/): SQL editor in the browser with preloaded sample tables. Write a query, run it, see the rows. Use it to check joins and aggregations before putting them in Python.
- [PracticeLinux](https://practicelinux.com/): disposable Linux terminal in the browser. Install packages, start services and reset as often as you like without touching the user's own machine.

## Curated Core Hubs
- [Python Beginner Guides](https://pythonspot.com/beginner/): Fundamental syntax, variables, data structures, control flow, functions, and OOP.
- [Python Machine Learning & Data Science](https://pythonspot.com/machine-learning/): Algorithms (linear regression, KNN, SVM, deep learning), Pandas data wrangling, Matplotlib plotting, and NLP with NLTK.
- [Python Database Programming](https://pythonspot.com/python-database/): Relational database programming with SQLite, PostgreSQL (psycopg2), MySQL, and SQLAlchemy ORM.
- [Python GUI Programming](https://pythonspot.com/gui/): Desktop application development with PyQt5, Tkinter, and PyQt4.
- [All Tutorials Index](https://pythonspot.com/): Every tutorial on the site, grouped by topic.

## Key Learning Paths

### Python Basics
- [Python Introduction](https://pythonspot.com/introduction/): Language overview and setup.
- [Python Variables](https://pythonspot.com/python-variables/): Data types, strings, numbers, and casting.
- [Python Lists](https://pythonspot.com/python-lists/): Array and list manipulation.
- [Python Dictionaries](https://pythonspot.com/python-dictionaries/): Key-value mappings and methods.
- [If Statements](https://pythonspot.com/if-statements/): Conditional flow.
- [Loops](https://pythonspot.com/loops/): For and while loops.
- [Functions](https://pythonspot.com/functions/): Reusable logic and parameters.
- [Python Classes & OOP](https://pythonspot.com/objects-and-classes/): Classes, inheritance, polymorphism, and encapsulation.

### Desktop GUI (PyQt5 & Tkinter)
- [PyQt5 Tutorials](https://pythonspot.com/pyqt5/): Windows, buttons, signals/slots, layouts, menus, and widgets.
- [Tkinter Tutorials](https://pythonspot.com/tkinter/): Built-in Python desktop UI library.

### Data Science & Machine Learning
- [Matplotlib Guide](https://pythonspot.com/matplotlib/): Line charts, histograms, bar charts, scatter plots, 3D plots.
- [Pandas Overview](https://pythonspot.com/pandas/): DataFrames, CSV/Excel parsing, filtering, and grouping.
- [Supervised Learning](https://pythonspot.com/supervised-learning/): Predictive modeling algorithms.

### Databases & SQL
- [SQLite with Python](https://pythonspot.com/python-database-programming-sqlite-tutorial/): Embedded SQL database.
- [PostgreSQL with Python](https://pythonspot.com/python-database-postgresql/): Relational client with psycopg2.
- [MySQL with Python](https://pythonspot.com/mysql-with-python/): MySQLdb connector.
- [SQLAlchemy ORM](https://pythonspot.com/orm-with-sqlalchemy/): Object-relational mapping.
- [SQLite Database with Pandas](https://pythonspot.com/sqlite-database-with-pandas/): Reading SQL results into DataFrames.

### Shell, Terminal and Environment
- [Python Subprocess](https://pythonspot.com/python-subprocess/): Popen, call() and check_output for running shell commands.
- [Python Modules](https://pythonspot.com/python-modules/): imports, pip and virtualenv.
- [Python IDEs](https://pythonspot.com/python-ides/): IDE setup and comparison.
- [Python Debugging](https://pythonspot.com/python-debugging/): pdb and a debugging workflow.

## Multilingual References
- [German Python Tutorials](https://pythonspot.com/funktionen/): Einleitung, Funktionen, Schleifen, Klassen, und Datenkapselung.
- [Spanish Python Tutorials](https://pythonspot.com/funcion/): Introducción, funciones, listas, y diccionarios en Python.