Python: From None to Machine Learning
latest
  • License
  • Install
  • Python Versions

Python Basics

  • 1. About
  • 2. Syntax
  • 3. Types
  • 4. Sequences
  • 5. Mappings
  • 6. Conditional
  • 7. Exception
  • 8. Loops
  • 9. Comprehensions
  • 10. Files
  • 11. Functions
  • 12. Object Oriented Programming
  • 13. Recap

Python Intermediate

  • 1. About
  • 2. Unpack
  • 3. Type Annotation
  • 4. Dataclass
  • 5. Pickle
  • 6. CSV
  • 7. JSON
  • 8. Regular Expressions
  • 9. Datetime and Timezones
  • 10. Operator
  • 11. Enum
  • 12. Logging
  • 13. Modules and Packages
  • 14. Locale
  • 15. Mathematics
  • 16. Tests
  • 17. References

Python Advanced

  • 1. About
  • 2. Generators
  • 3. Functional Programming
  • 4. Decorators
  • 5. Object Oriented Programming
  • 6. Performance
  • 7. Concurrency
  • 8. Recap

Database

  • 1. About
  • 2. Theory
  • 3. Normalization
  • 4. NoSQL
  • 5. SQL
  • 6. SQLite3
  • 7. SQLAlchemy
    • 7.1. SQLAlchemy About
    • 7.2. Connection DSN
    • 7.3. Connection Engine
    • 7.4. Connection Pool
    • 7.5. Core Model
    • 7.6. Core Operators
    • 7.7. Core Insert
    • 7.8. Core Select
    • 7.9. Core Result
    • 7.10. Core Update
    • 7.11. Core Delete
    • 7.12. Core Join
    • 7.13. Core Text
    • 7.14. Core Introspect
    • 7.15. ORM About
    • 7.16. Connection Session
    • 7.17. Model Base
    • 7.18. Model Define
    • 7.19. Model Column
    • 7.20. Model Types
    • 7.21. Model Indexes
    • 7.22. Model Relations
    • 7.23. Model Dataclass
    • 7.24. Schema Metadata
    • 7.25. Schema Reflection
    • 7.26. Migration About
    • 7.27. Migration Create
    • 7.28. Migration Apply
    • 7.29. Migration Rollback
    • 7.30. Query About
    • 7.31. Query Fetch
    • 7.32. Query Filter
    • 7.33. Query Limit
    • 7.34. Query Order By
    • 7.35. Query Group By
    • 7.36. Query Subquery
    • 7.37. Query Union
      • 7.37.1. Union
      • 7.37.2. Union All
      • 7.37.3. Intersect
      • 7.37.4. Intersect All
    • 7.38. Query Join
    • 7.39. Query Count
    • 7.40. Query Distinct
    • 7.41. Query Exists
    • 7.42. Query Update
    • 7.43. Query Delete
    • 7.44. Query Execute
    • 7.45. Query Debug
    • 7.46. Query Profile
    • 7.47. Func About
    • 7.48. Func Date
    • 7.49. Func Group
    • 7.50. Func Numeric
    • 7.51. Func Count
    • 7.52. Func Count
    • 7.53. SQLAlchemy Use Cases
  • 8. Case Study

Design Patterns

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

Numpy

  • 1. About
  • 2. Create
  • 3. Attributes
  • 4. Indexing
  • 5. Methods
  • 6. Random
  • 7. Operations
  • 8. Statistics
  • 9. Math
  • 10. Import & Export
  • 11. Polynomial
  • 12. References

Pandas

  • 1. About
  • 2. Import & Export
  • 3. Series
  • 4. DataFrame
  • 5. Date
  • 6. Recap
  • 7. Case Studies

Matplotlib

  • 1. About
  • 2. Figure
  • 3. Style
  • 4. Chart
  • 5. Advanced
  • 6. Recap

Stdlib

  • 1. Modules and Packages
  • 2. Mathematics
  • 3. XML
  • 4. Operating System
  • 5. Builtin
  • 6. Looping

DevOps

  • 1. About
  • 2. Good Engineering Practices
  • 3. Tests
  • 4. Debugging
  • 5. Type Annotation
  • 6. CI/CD

Network

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

HTTP and Microservices

  • 1. HTTP Protocol
  • 2. Microservices
  • 3. 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. Type Annotation
  • 3. JSON
  • 4. HTTP
  • 5. Async
  • 6. FastAPI
  • 7. Pydantic
  • 8. Database
  • 9. Auth
  • 10. DevOps
  • 11. Microservices
  • 12. Appendix

Data Science

  • 1. About
  • 2. Jupyter
  • 3. Python
  • 4. Data 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

Object Oriented Programming

  • 1. Paradigm
  • 2. Python
  • 3. Dynamic Typing

Blogposts

  • 1. Machine Learning Introduction

Dragon

  • 1. Dragon (version alpha)
  • 2. Dragon (version beta)
  • 3. Dragon (version release candidate)
  • 4. Moon Landing
  • 5. Dragon ADR Init Name
  • 6. Dragon ADR Init Position
  • 7. Dragon ADR Position Set
  • 8. Dragon ADR Position Change
  • 9. Dragon ADR Damage Make
  • 10. Dragon ADR Damage Take
  • Writing Progress
  • References in the Book
  • Survey
  • Python History
  • 13.3. Further reading
Python: From None to Machine Learning
  • Docs »
  • 1. About »
  • 7.37. Query Union
  • Edit on GitHub

7.37. Query Union¶

  • Union

  • Union All

  • Intersect

  • Intersect All

7.37.1. Union¶

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

7.37.2. Union All¶

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

7.37.3. Intersect¶

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

7.37.4. Intersect All¶

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

Next Previous

© Copyright 2022, CC-BY-SA-4.0, Matt Harasymczuk <matt@astrotech.io>, last update: 2022-06-27 Revision 672de124.

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

Free document hosting provided by Read the Docs.