Wrapping up

Python for Spreadsheet Users

Chris Cardillo

Data Scientist

Chapter 1

• Importing with pd.read_excel()
• Understanding with .head(), .describe(), and .info()
• Filtering with df[df[column] == 'value']
• Creating with df[new_column] = df[old_column] + 1

Chapter 2

• Pivoting with df.group_by().sum()

Chapter 3

• Multiple sheets with pd.ExcelFile() and .parse()
• .merge() and left joins
• Functions, methods, and attributes

Chapter 4

• sns.barplot() and plt.show()
• plt.title(), plt.xlabel(), and plt.ylabel()
• sns.set_style() and sns.despine()
• hue

Next Steps

• Course Suggestion: Data Manipulation with pandas
• Career Track Suggestion: Data Analyst with Python
• DataCamp Community Resource: Cheat Sheets

Good luck!

Python for Spreadsheet Users