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 […]...
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 […]...
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 […]...
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 […]...