DataFrame as labeled two-dimensional table in Pandas - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a DataFrame in pandas?

A DataFrame is a labeled two-dimensional table in pandas. It has rows and columns, where each column can have a different type of data, like numbers or text.

beginner

How are rows and columns labeled in a DataFrame?

Rows are labeled by an index, which can be numbers or custom labels. Columns have names that describe the data they hold.

beginner

How can you create a simple DataFrame from a dictionary in pandas?

You can pass a dictionary where keys are column names and values are lists of data. For example: <br>pd.DataFrame({'Name': ['Anna', 'Bob'], 'Age': [25, 30]})

beginner

What does it mean that a DataFrame is two-dimensional?

It means the data is organized in rows and columns, like a table or spreadsheet. You can think of it as a grid where each cell holds a value.

beginner

Why is labeling rows and columns useful in a DataFrame?

Labels help you find and select data easily. Instead of just numbers, you can use meaningful names to understand and work with your data better.

What is the main structure of a pandas DataFrame?

A A three-dimensional array

B A one-dimensional list

C A two-dimensional labeled table

D A simple number

A DataFrame is a two-dimensional table with labels for rows and columns.

How do you label rows in a DataFrame?

A Using cell values

B Using the index

C Using column names

D Using data types

Rows are labeled by an index, which can be numbers or custom labels.

Which pandas function creates a DataFrame from a dictionary?

A pd.Series()

B pd.table()

C pd.array()

D pd.DataFrame()

pd.DataFrame() creates a DataFrame, often from a dictionary of lists.

What kind of data can columns in a DataFrame hold?

A Different types like numbers and text

B Only text

C Only numbers

D Only dates

Each column can hold different types of data, such as numbers, text, or dates.

Why are column names important in a DataFrame?

A They help identify what data each column holds

B They store data values

C They are not important

D They label rows

Column names describe the data in each column, making it easier to understand and use.

Explain what a DataFrame is and how it organizes data.

Think of a spreadsheet with named columns and numbered or named rows.

Describe how you would create a simple DataFrame using pandas.

Start with a dictionary where each key is a column name.