Joining two or more data sets together is a common operation that GIS Analysts perform. This can be done with Python. Some perquisites for joining data include creating (making) feature layers or tables views from feature classes or tables. Also, creating (adding) one or more indexes on data columns is good practice for larger datasets.
See the Ch 6 Demo Scripts, Data, and Jupyter Notebooks zip file to review and practice the concepts shown in these videos. This section corresponds to the Chapter 6 content in the Python Primer for ArcGIS Workbook (vol 2).
This video shows the process to work with attribute indexes, create (add) a join between a feature layer and table view, use the joined data in a search cursor process, and then remove the join after it is no longer needed.