↓ Skip to Main Content
Useful code Programming with VBA, C# and Python

Main Navigation

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About
Useful code Programming with VBA, C# and Python

Off Canvas Menu

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About

Tag: union

Home › Posts tagged union
VBA and Python – Intersection of dictionaries
Python, VBA \ Excel

VBA and Python – Intersection of dictionaries

Vitosh Apr 4, 2021 Tagged with dictionary, difference, Excel, intersection, Python, union, VBA

Intersection of dictionary (or of any two lists) is a list with elements, that are present in both other lists. Thus, if we have the following 3 dictionaries in Python: dict_a = dict([(‘aa’, 4139), (‘bb’, 4127), (‘cc’, 4098)]) dict_b = …

VBA and Python – Intersection of dictionaries Read more →

Connecting SqlLite3 database to Python and Reading it
Python

Connecting SqlLite3 database to Python and Reading it

Vitosh Oct 31, 2019 Tagged with database, Python, SqlLite3, union

Connecting SqlLite3 database to a Python file is actually 1 line of code: conn = sqlite3.connect(r”C:\Users\database.db”) I have used a database from sqllitetutorial.net, which was rather neat. Then DB Browser for SQLLite a LEFT JOIN was implemented, in order to …

Connecting SqlLite3 database to Python and Reading it Read more →

Sets in Python – Differece, Symetric Difference, Union, Intersection
Python

Sets in Python – Differece, Symetric Difference, Union, Intersection

Vitosh Oct 23, 2019 Tagged with intersection, Python, sets, symmetric difference, union

After writing the article scraping a web site up to the N-th level with Python, I have decided to summarize what could be achieved with Set() in this language. Pretty much, sets can be described as lists with a few …

Sets in Python – Differece, Symetric Difference, Union, Intersection Read more →

Copyright © 2026 VitoshAcademy