Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Aprenda Adding new Columns | Basics of Dataframes
Pandas: First Steps
course content

Conteúdo do Curso

Pandas: First Steps

Pandas: First Steps

1. Getting Started
Introduction to PandasSeriesTask: Coffee Orders SeriesTask: Barista's Favorites CoffeesAccessing Elements from a SeriesTask: Drink of the HourTask - Signature DrinksTask: Mid-Morning SpecialsTask - Fetching the Mid-Shift DrinksOperations over SeriesTask: Modifying a single elementTask: Modifying the Entire SeriesTask: Modifying Part of a SeriesTask: Processing the Restock of Inventory
2. Basics of Dataframes
What is a DataFrame?Task: Creating a Table of Popular Coffee DrinksTask: Tracking Coffee Bean DeliveriesTask: Weekly Coffee Sales ReportAdding new ColumnsTask: Finding Total Sales Per DrinkTask: Calculating Total Sales RevenueAdding new RowsTask: Adding a New Employee to the Café TeamTask: Adding New Coffee Types to the Café Menu
3. Fetching Data from DataFrames
The `head()` MethodTask: Preview the Coffee MenuThe `tail()` MethodTask: Finding the Most Expensive CoffeesThe `sample()` MethodTask: Randomly Select Customer Orders for Quality CheckExtracting Multiple ColumnsTask: Extracting the Total ProfitTask: Extract Sales Data For AnalysisThe `iloc` PropertyTask: Access Sales Data at Café Pandasia - Part 1Task: Access Sales Data at Café Pandasia - Part 2Task: Access Sales Data at Café Pandasia - Part 3

book
Adding new Columns

We can easily add new columns to an existing DataFrame using the indexing syntax:

js

It is important that if values is a list, it needs to have the same number of elements as there are rows in the DataFrame, otherwise you'll get an error. Alternatively, we can assign a single value to the entire new column as well.

Example 1: New Column from a Single Value


              
1234567891011

            
import pandas as pd

df = pd.DataFrame({
    'Product': ['Laptop', 'Tablet', 'Phone'],
    'Old Price': [1000, 600, 400]
})

# Add a new column with a fixed price for all rows
df['New Price'] = 700

print(df)
copy

Example 2: New Column using a List of Values


              
1234567891011

            
import pandas as pd

df = pd.DataFrame({
    'Member': ['Sophie', 'Liam', 'Emma'],
    'Role': ['Designer', 'Developer', 'Tester']
})

# Add a new column for Project Name
df['Project'] = ['Marketing Website Redesign', 'Client Portal Backend Development', 'Payment Flow QA Testing']

print(df)
copy

Example 3: New Column derived from Another Column


              
1234567891011

            
import pandas as pd

df = pd.DataFrame({
    'Product': ['Laptop', 'Tablet', 'Phone'],
    'Price': [1000, 600, 400]
})

# Derive a new column 'Discounted Price' (10% off)
df['Discounted Price'] = df['Price'] * 0.9

print(df)
copy

1. What happens if you try to add a new column to a DataFrame with a list that has fewer elements than the number of rows?

2. Which of the following lines correctly adds a column Discount which is 20% of the Price?

3. What would be the output of the following code?

question mark

What happens if you try to add a new column to a DataFrame with a list that has fewer elements than the number of rows?

Select the correct answer

question mark

Which of the following lines correctly adds a column Discount which is 20% of the Price?

Select the correct answer

question mark

What would be the output of the following code?

Select the correct answer

Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 2. Capítulo 5

Pergunte à IA

expand
ChatGPT

Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo

course content

Conteúdo do Curso

Pandas: First Steps

Pandas: First Steps

1. Getting Started
Introduction to PandasSeriesTask: Coffee Orders SeriesTask: Barista's Favorites CoffeesAccessing Elements from a SeriesTask: Drink of the HourTask - Signature DrinksTask: Mid-Morning SpecialsTask - Fetching the Mid-Shift DrinksOperations over SeriesTask: Modifying a single elementTask: Modifying the Entire SeriesTask: Modifying Part of a SeriesTask: Processing the Restock of Inventory
2. Basics of Dataframes
What is a DataFrame?Task: Creating a Table of Popular Coffee DrinksTask: Tracking Coffee Bean DeliveriesTask: Weekly Coffee Sales ReportAdding new ColumnsTask: Finding Total Sales Per DrinkTask: Calculating Total Sales RevenueAdding new RowsTask: Adding a New Employee to the Café TeamTask: Adding New Coffee Types to the Café Menu
3. Fetching Data from DataFrames
The `head()` MethodTask: Preview the Coffee MenuThe `tail()` MethodTask: Finding the Most Expensive CoffeesThe `sample()` MethodTask: Randomly Select Customer Orders for Quality CheckExtracting Multiple ColumnsTask: Extracting the Total ProfitTask: Extract Sales Data For AnalysisThe `iloc` PropertyTask: Access Sales Data at Café Pandasia - Part 1Task: Access Sales Data at Café Pandasia - Part 2Task: Access Sales Data at Café Pandasia - Part 3

book
Adding new Columns

We can easily add new columns to an existing DataFrame using the indexing syntax:

js

It is important that if values is a list, it needs to have the same number of elements as there are rows in the DataFrame, otherwise you'll get an error. Alternatively, we can assign a single value to the entire new column as well.

Example 1: New Column from a Single Value


              
1234567891011

            
import pandas as pd

df = pd.DataFrame({
    'Product': ['Laptop', 'Tablet', 'Phone'],
    'Old Price': [1000, 600, 400]
})

# Add a new column with a fixed price for all rows
df['New Price'] = 700

print(df)
copy

Example 2: New Column using a List of Values


              
1234567891011

            
import pandas as pd

df = pd.DataFrame({
    'Member': ['Sophie', 'Liam', 'Emma'],
    'Role': ['Designer', 'Developer', 'Tester']
})

# Add a new column for Project Name
df['Project'] = ['Marketing Website Redesign', 'Client Portal Backend Development', 'Payment Flow QA Testing']

print(df)
copy

Example 3: New Column derived from Another Column


              
1234567891011

            
import pandas as pd

df = pd.DataFrame({
    'Product': ['Laptop', 'Tablet', 'Phone'],
    'Price': [1000, 600, 400]
})

# Derive a new column 'Discounted Price' (10% off)
df['Discounted Price'] = df['Price'] * 0.9

print(df)
copy

1. What happens if you try to add a new column to a DataFrame with a list that has fewer elements than the number of rows?

2. Which of the following lines correctly adds a column Discount which is 20% of the Price?

3. What would be the output of the following code?

question mark

What happens if you try to add a new column to a DataFrame with a list that has fewer elements than the number of rows?

Select the correct answer

question mark

Which of the following lines correctly adds a column Discount which is 20% of the Price?

Select the correct answer

question mark

What would be the output of the following code?

Select the correct answer

Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 2. Capítulo 5
Sentimos muito que algo saiu errado. O que aconteceu?
some-alt