DataFrame Methods and Merging in Pandas

0.0(0)
studied byStudied by 1 person
linked notesView linked note
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/8

flashcard set

Earn XP

Description and Tags

Flashcards covering key Pandas methods related to DataFrames, including how to manipulate and merge data.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

9 Terms

1
New cards

drop()

Method used to remove specified labels from rows or columns.

2
New cards

drop_duplicates()

Method that removes duplicate rows from a DataFrame based on specified column(s).

3
New cards

dropna()

Method used to remove rows or columns that contain missing values.

4
New cards

sort_values()

Method to sort DataFrame by the values of a specified column.

5
New cards

merge()

Method for merging two DataFrames on a specified key.

6
New cards

inner join

A type of join that returns only the rows where there are matches in both DataFrames.

7
New cards

left join

A type of join that returns all rows from the left DataFrame and matched rows from the right DataFrame.

8
New cards

right join

A type of join that returns all rows from the right DataFrame and matched rows from the left DataFrame.

9
New cards

outer join

A type of join that returns all rows when there is a match in either left or right DataFrame.