Jupyter Notebook으로 시작하는 Python
박범진
코딩 결과를 바로 확인 할 수 있는 jupyter notebook 을 통하여 python 의 기초를 짧게 담아보고자 하였습니다.
Basic
Python
This is not a complete list of Google Spreadsheets, but rather a collection of only the things I use to preprocess data in my field.
How to use Google Spreadsheets Basics
Data preprocessing using Google Sheets
Processing Data with Google Spreadsheets : A Guide from a Professional 👨💻
As a data analyst at a platform company, one of the most essential tasks is data extraction . This means processing information stored in databases and providing it to those who need it. Programming languages like SQL and Python are commonly used for this, but Google Sheets allows for more efficient data processing. However, spreadsheets offer so many features that it can be overwhelming to know which ones to learn. Therefore, in this lecture, I've introduced the key features and functions I use in my field for data processing .
✅ Rather than focusing on theory, we have created a system that focuses on possible examples to help you think about the relevant situations.
✅ We provide practice files so that you can practice along with the lectures, not just watch them.
✅ This course is verified as it is based on spreadsheet training conducted in-house .
Q. How is this different from previous lectures?
A. I created this book by selecting only the grammar and functions I use in my field. Therefore, rather than covering everything about spreadsheets, I focused on only the essentials.
Q. What is not covered in this course?
A. This lecture focuses on preprocessing raw data, so it does not cover creating charts or dashboards.
Q. Do you have any plans for additional lectures on spreadsheets?
A. I am thinking about charts/dashboards and automation, which are not covered in this course.
Who is this course right for?
For those who are new to Google Sheets (Excel)
Those who received data from data analysts but had difficulty preprocessing
People who have computer skills but cannot use Google Sheets (Excel)
9,731
Learners
429
Reviews
15
Answers
4.8
Rating
8
Courses
- 현) KREAM 데이터 분석가
- 전) ABLY 데이터 분석가
- 전) wadiz 데이터 분석가
- 전) XIILab 인공지능개발팀 선임연구원
- 전) 아라종합기술 수치모델링1팀 사원
- 인하대학교 해양과학과 (학/석)
All
18 lectures ∙ (52min)
Course Materials:
3. Cell Basis
03:56
4. Fixed frame
02:49
6. Format
02:35
7. Cell counting
01:54
9. reference
02:50
10. vlookup
04:53
11. iferror
03:12
12. arrayformula
03:30
13. split
01:52
14. Filtering
01:11
17. Pivot Table
03:22
All
78 reviews
4.8
78 reviews
$4.40
Check out other courses by the instructor!
Explore other courses in the same field!