Let's get right into it! In this chapter, you'll become acclimated with Python syntax, loading your data into a Python session, and how to explore and edit this data to answer business questions.

Selamat datang di Python!

Mengimpor paket

Memuat data

Melihat data dengan print()

DataFrame dan metodenya

Metode .head()

Metode .info() dan .describe()

Metode .sort_values()

Menyaring baris dan membuat kolom

Penyaringan

Membuat kolom

Menggabungkan semuanya

Diving In

The pivot table is a core tool in the savvy spreadsheet user's arsenal. In this chapter, we'll focus on simply recreating this functionality in Python using some handy DataFrame methods.

Grouping and summing: the beginner's pivot table

Pure summary with .sum()

.groupby() and .sum() together

Summarizing and sorting values

Grouping by multiple columns

Which is a list?

Movie genre performance by location

What do seniors like?

More useful summary tools

Best-selling movie by location

Which movie averages the most sales

Pivoting in Python

This chapter will focus on how to import and manage multiple sheets from a workbook, as well as how to join these sheets together using the Python equivalent of a VLOOKUP: the left join.

Working with multiple sheets

pd.ExcelFile() function

.sheet_names attribute

.parse() method

Preparing to put tables together

.str.lower() and .str.title()

.str.strip()

Selecting and .drop()

Merging: The VLOOKUP of Python

Merging for ticket prices

Merging for theater locations

Putting it all together again

Working with Multiple Sheets

Now that you're able to import and manipulate your data in Python, let's shift our focus to visualizing this data so that our insights are easily communicable to others.

How visualization works in Python

How to build a graph in Python

Top grossing films

Best genres

Building up the barplot

Put a title on it

Label your axes!

Make it pretty with sns

The power of hue

Interpreting hue

Genre by market

Genre by ticket type

Wrapping up

Plotting Data

Movie Theater Sales dataset

Apakah Anda mencari solusi yang lebih baik daripada yang telah Anda bangun di spreadsheet? Jika ya, maka Python untuk Pengguna Spreadsheet adalah pengantar yang tepat untuk bahasa Python dan akan menempatkan Anda di jalur yang benar untuk mengotomatiskan pekerjaan berulang, mengeksplorasi data lebih dalam, dan memperluas cakupan kemampuan Anda. Sepanjang kursus, kami akan menarik paralel dengan fungsi dan teknik spreadsheet yang umum, sehingga Anda selalu memiliki titik acuan yang familier saat mulai terjun ke Python.

Pivot Tables in Google Sheets

Gunakan pengetahuan fungsi spreadsheet untuk menjelajahi Python!

Python untuk Pengguna Spreadsheet

Gunakan pengetahuan Anda tentang fungsi dan teknik spreadsheet umum untuk menjelajahi Python! 

DataFrame dan metodenya

Create Your Free Account