강의

멘토링

로드맵

Inflearn brand logo image
Programming

/

Database

PYTHON written like SQL

You can learn how to handle data frames (tables) using Python, similar to the SELECT statement in SQL.

(5.0) 10 reviews

114 learners

  • pbj0812
3시간 만에 완강할 수 있는 강의 ⏰
Python
SQL
Pandas

Reviews from Early Learners

What you will learn!

  • Python Basic Grammar

  • Python Pandas

  • How to use Google Colab

  • Data Preprocessing Using Python

Python, written like SQL, easy and simple!

Attention these people!

  • People who need to deal with CSV files but only know SQL (Prerequisite: SQL)

I learned SQL
Do I have to do Python too? 😵

I need to deal with CSV files, but I only know SQL...

“Learning SQL was difficult, and now I have to learn a new language again...”
“How do I install Python...” (burden)

Recently, not only developers but also marketers and planners have been using SQL more and more. This is because they can directly access the database and extract data using SQL queries.

But what if these people who only know how to handle SQL are given a CSV file that is used in Excel instead of a database? Even if it has the same data structure, it will not be easy to handle.

(CSV...??)

However, in actual work, there are many times when you create and handle data frames from CSV files rather than databases. In such cases, it would be inefficient to ask for help from others or directly push CSV into the database as a table and then reprocess the data using SQL language.

So in this lecture, we will learn how to use SQL like a SELECT statement with CSV files using a language called Python . If you are looking for a way to handle CSV files and data frames as well as SQL, and if you want to easily and conveniently output the results you want in Python, pay attention!

So, this is what you learn.

✅ Learn how to handle data frames (tables) like SQL using various Python syntax and functions.
✅ We explain concepts in SQL in a 1:1 match with Python as much as possible, focusing on practice.


You will learn: 📖

  • This lecture assumes that the student knows basic SQL grammar, so those who know the SQL language will find it easier to follow.
  • Since the course focuses on practical examples rather than theory, you can immediately apply what you have learned.
  • I provide problems that I have obtained while using SQL in the field, converted to Python. I think you can solve most of the problems you actually need. (This lecture consists of about 500 cells.)
  • As the name of the lecture suggests, I will explain the concepts in SQL in a 1:1 match as much as possible. Therefore, I will proceed excluding explanations of loop statements, which are essential in basic Python lectures.
  • I know that many people, including myself, dislike installation... or find it difficult, so we proceeded with Colab, which does not require Python installation.

Learning Curriculum 📚

1. Python Basics

We'll give you a brief introduction to Google Colab and learn the basic grammar of Python.

2. SELECT

Just like writing a SELECT statement in SQL, you can learn how to extract only the field names you want from the data you have, change the date display format, etc.

3. WHERE

You will learn how to retrieve only the data that matches the conditions you want, like in the WHERE clause in SQL.

4. GROUP BY

You can perform simple statistics (sum, check quantity, etc.) based on specific field(s), as in the GROUP BY clause of SQL.

5-6. JOIN, UNION

You can learn how to combine two tables, such as JOIN and UNION in SQL.


Q&A 💬

Q. Can I learn everything about Python through this course?

This course was created based on implementing the SELECT statement in SQL. I do not recommend it if you want to study the Python language itself.

Q. Will the theories covered in the lecture be very complicated?

Since this course is focused on practice rather than theory, I don't think there will be any parts that are difficult to understand.

Q. Do I have to know SQL to take this course?

There may not be any difficulty in listening to the lecture itself, but there may be some parts where the explanation is insufficient because the analogy is given using SQL. (Recommended for those who already know SQL.)

Q. Do you plan to create other lectures?

In addition to this lecture, we are currently planning several other items.


Introducing the knowledge sharer 👨‍💻

Park Beom-jin

Are you curious about other lectures by the knowledge sharer?

Getting Started with Python with Jupyter Notebook (Click)

Data analysis starting with SQL and Google Sheets (Click)

SELECT ALL FROM SQL (Click)

PYTHON like MATLAB (Click)

Recommended for
these people

Who is this course right for?

  • Anyone who wants to control a CSV file made up of data

  • If you want to use Python like SQL

Need to know before starting?

  • SQL

Hello
This is

9,731

Learners

429

Reviews

15

Answers

4.8

Rating

8

Courses

- 현) KREAM 데이터 분석가

- 전) ABLY 데이터 분석가

- 전) wadiz 데이터 분석가

- 전) XIILab 인공지능개발팀 선임연구원

- 전) 아라종합기술 수치모델링1팀 사원

- 인하대학교 해양과학과 (학/석)

Curriculum

All

27 lectures ∙ (2hr 11min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

10 reviews

5.0

10 reviews

  • jtk920172님의 프로필 이미지
    jtk920172

    Reviews 6

    Average Rating 5.0

    5

    33% enrolled

    The balance between lectures (theory) and colab (practice) is good. It's perfect for beginners to follow.

    • pbj0812
      Instructor

      thank you!!!!

  • jeonghyunlee5600님의 프로필 이미지
    jeonghyunlee5600

    Reviews 3

    Average Rating 5.0

    5

    100% enrolled

    I heard it so well.

    • pbj0812
      Instructor

      Thank you for the course review!!!!

  • johyunshin4116님의 프로필 이미지
    johyunshin4116

    Reviews 2

    Average Rating 4.5

    5

    100% enrolled

    It's organized in an easy-to-understand way!

  • mons님의 프로필 이미지
    mons

    Reviews 27

    Average Rating 5.0

    5

    100% enrolled

    It was a good lecture.

  • neomirage님의 프로필 이미지
    neomirage

    Reviews 62

    Average Rating 5.0

    5

    100% enrolled

    It's nice to look at it lightly~

$8.80

pbj0812's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!