Tag: Python

Merging dataframes with Pandas

Performing Anti-Joins Merge employees and top_cust with a left join, setting indicatorargument to True. Save the result to empl_cust. Select the srid column of empl_cust and the rows where _merge is 'left_only'. Save the result to srid_list. Subset the employees table and select those rows where the srid is in the variable srid_list and print the results. Success! You performed an anti-join by first merging the tables with a left...

Object Oriented Programming in Python

In normal life to tend to think in sequences of activities. Procedural programming Code as a sequence of steps Great for data analysis and scripts Object-oriented programming Code as interactions of objects Great for building framework and tools Maintainable and reusable code! Objects as datastructures Object = state +...

How to create a DataFrame in Pandas from a list and add columns

Imagine we have a list and we want to be able to use it as a Pandas DataFrame in Python, how do we do that? And just for fun, I got my inspiration for these delicious fruits from this website: https://www.whateatly.com/category/fruits/ Never mind, now we created and printed our...

Reading a .csv file with Python and creating a DataFrame

In this chapter I will dive into reading the data in .csv file and creating a DataFrame. A .csv file stands for comma-separated value, so it simply contains a set of values separated by a comma where each line is a new record in plain text. For this exercise...