Python: From None to Machine Learning
latest
  • License
  • Python Versions
  • References in the Book
  • Survey
  • Python History
  • Further reading

Agenda

  • Python: Basics
  • Python: Intermediate (level 1)
  • Python: Intermediate (level 2)
  • Python: Advanced
  • Python: Design Patterns
  • Python: Test Driven Development
  • Python: DevOps, CI/CD
  • Python: Performance Optimization
  • Python: Data Science and Analysis
  • Python: Numpy
  • Python: Pandas
  • Python: Microservices
  • Python: Django
  • Python: FastAPI
  • Python: Flask
  • Python: Graphical User Interface

Install

  • 1. Install
  • 2. Install Python
  • 3. Install Git
  • 4. Install Github
  • 5. Install IDE
  • 6. Install Project
  • 7. Install Doctest

Basics

  • 1. About
  • 2. Syntax
  • 3. Types
  • 4. Iterables
  • 5. Unpack
  • 6. Mappings
  • 7. Conditional
  • 8. Loops
  • 9. Comprehensions
  • 10. Files
  • 11. Functions
  • 12. Exception
  • 13. OOP

Intermediate

  • 1. About
  • 2. Star
  • 3. Match
  • 4. Idiom
  • 5. Generators
  • 6. JSON
  • 7. CSV
  • 8. TOML
  • 9. Pickle
  • 10. Regex
  • 11. Datetime
  • 12. Enum
  • 13. Modules
  • 14. Logging
  • 15. Math
  • 16. Tests

Advanced

  • 1. About
  • 2. Syntax
  • 3. Typing
  • 4. Dataclass
  • 5. OOP
  • 6. Operator
  • 7. Protocol
  • 8. Functional
  • 9. Decorators
  • 10. Performance
  • 11. Multiprocessing
  • 12. Threading
  • 13. AsyncIO

Database

  • 1. About
  • 2. Theory
  • 3. ORM
  • 4. Normalization
  • 5. NoSQL
  • 6. SQL
  • 7. SQLite3
  • 8. SQLAlchemy
    • 8.1. SQLAlchemy About
    • 8.2. Connection DSN
    • 8.3. Connection Engine
    • 8.4. Connection Pool
    • 8.5. Core Model
    • 8.6. Core Operators
    • 8.7. Core Insert
    • 8.8. Core Select
    • 8.9. Core Result
    • 8.10. Core Update
    • 8.11. Core Delete
    • 8.12. Core Join
    • 8.13. Core Text
    • 8.14. Core Introspect
    • 8.15. ORM About
    • 8.16. Connection Session
    • 8.17. Model Base
    • 8.18. Model Define
    • 8.19. Model Column
    • 8.20. Model Types
    • 8.21. Model Indexes
    • 8.22. Model Relations
    • 8.23. Model Dataclass
    • 8.24. Schema Metadata
    • 8.25. Schema Reflection
    • 8.26. Migration About
    • 8.27. Migration Create
    • 8.28. Migration Apply
    • 8.29. Migration Rollback
    • 8.30. Query About
    • 8.31. Query Fetch
    • 8.32. Query Filter
    • 8.33. Query Limit
    • 8.34. Query Order By
    • 8.35. Query Group By
    • 8.36. Query Subquery
    • 8.37. Query Union
    • 8.38. Query Join
    • 8.39. Query Count
    • 8.40. Query Distinct
      • 8.40.1. Distinct
    • 8.41. Query Exists
    • 8.42. Query Update
    • 8.43. Query Delete
    • 8.44. Query Execute
    • 8.45. Query Debug
    • 8.46. Query Profile
    • 8.47. Func About
    • 8.48. Func Date
    • 8.49. Func Group
    • 8.50. Func Numeric
    • 8.51. Func Count
    • 8.52. Func Count
    • 8.53. SQLAlchemy Extensions
    • 8.54. Case Study
    • 8.55. SQLAlchemy Use Cases
  • 9. Case Study

Design Patterns

  • 1. About
  • 2. UML
  • 3. OOP
  • 4. Protocols
  • 5. Decorators
  • 6. Behavioral
  • 7. Structural
  • 8. Creational
  • 9. Practices
  • 10. Paradigms

Numpy

  • 1. About
  • 2. Create
  • 3. Attributes
  • 4. Random
  • 5. Indexing
  • 6. Operations
  • 7. Methods
  • 8. Statistics
  • 9. Math
  • 10. Polynomial

Pandas

  • 1. About
  • 2. Read
  • 3. To
  • 4. Series
  • 5. DataFrame
  • 6. Date
  • 7. Case Study

Matplotlib

  • 1. About
  • 2. Figure
  • 3. Style
  • 4. Chart
  • 5. Case Study

Stdlib

  • 1. Modules
  • 2. Collections
  • 3. Math
  • 4. Locale
  • 5. Pickle
  • 6. XML
  • 7. Operating System
  • 8. Builtin
  • 9. Loop
  • 10. Performance
  • 11. TKInter

DevOps

  • 1. About
  • 2. Quality
  • 3. Tests
  • 4. Debugging
  • 5. CI/CD

Network

  • 1. About
  • 2. Protocols
  • 3. Web
  • 4. Transport

Microservices

  • 1. About
  • 2. Protocol
  • 3. Microservices
  • 4. Auth

Django

  • 1. About
  • 2. Conf
  • 3. Models
  • 4. Admin
  • 5. ORM
  • 6. Views
  • 7. Utils
  • 8. API
  • 9. DevOps
  • 10. Async

FastAPI

  • 1. About
  • 2. FastAPI
  • 3. Pydantic
  • 4. Database
  • 5. Auth
  • 6. DevOps
  • 7. Case Study

Data Science

  • 1. About
  • 2. Jupyter
  • 3. Python
  • 4. Visualization
  • 5. Scipy

Machine Learning

  • 1. About
  • 2. Introduction
  • 3. Sklearn
  • 4. Model Quality
  • 5. Decision Trees
  • 6. Regressions
  • 7. K-Nearest Neighbors
  • 8. Bayes
  • 9. Support Vector Machines
  • 10. Clustering
  • 11. Neural Networks
  • 12. References
  • 13. Articles

OOP

  • 1. Paradigm
  • 2. Python

Dragon

  • 1. English
  • 2. Polish
  • 3. ADR
Python: From None to Machine Learning
  • 1. About
  • 8.40. Query Distinct
  • Edit on GitHub

8.40. Query Distinct¶

  • Distinct

8.40.1. Distinct¶

  • https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.distinct

Previous Next

© Copyright 2023, CC-BY-SA-4.0, Matt Harasymczuk <matt@astronaut.center>, last update: 2023-11-27. Revision d224dbbc.

Read the Docs v: latest
Versions
latest
Downloads
On Read the Docs
Project Home
Builds