Inserting a New Column
Next, explore another way to add a column to a DataFrame using the insert() method. This method allows you to specify the position of the new column within the DataFrame.
df.insert(column_index, 'column_name', [value_1, value_2, value_3])
df: the name of the existing DataFrame;insert(): the method used for adding new columns;column_index: the position where the new column will be inserted (keep in mind that indexing starts at 0);column_name: the name for the new column;[value_1, value_2, value_3]: the values that will populate the new column.
Focus on the countries DataFrame and add a new column named 'population', which represents the populations of countries, right after the first column ('country').
12345678import pandas as pd countries_data = {'country' : ['Thailand', 'Philippines', 'Monaco', 'Malta', 'Sweden', 'Paraguay', 'Latvia'], 'continent' : ['Asia', 'Asia', 'Europe', 'Europe', 'Europe', 'South America', 'Europe'], 'capital':['Bangkok', 'Manila', 'Monaco', 'Valletta', 'Stockholm', 'Asuncion', 'Riga']} countries = pd.DataFrame(countries_data) countries.insert(1, 'population', [61399000, 75967000, 39244, 380200, 10380491, 5496000, 2424200]) print(countries)
Swipe to start coding
You are given a list named cars_data.
- Given this list, create a
DataFramenamedaudi_cars. - Insert a column named
'price'between the'year'and'fueltype'columns and populate this column with the following values:[12500, 16500, 16800, 17300, 13900].
Solution
Thanks for your feedback!
single
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Can you explain what happens if the list of values for the new column doesn't match the number of rows in the DataFrame?
How can I insert a column at the end of the DataFrame instead of a specific position?
What happens if I try to insert a column with a name that already exists in the DataFrame?
Awesome!
Completion rate improved to 3.03Inserting a New Column
Swipe to show menu
Next, explore another way to add a column to a DataFrame using the insert() method. This method allows you to specify the position of the new column within the DataFrame.
df.insert(column_index, 'column_name', [value_1, value_2, value_3])
df: the name of the existing DataFrame;insert(): the method used for adding new columns;column_index: the position where the new column will be inserted (keep in mind that indexing starts at 0);column_name: the name for the new column;[value_1, value_2, value_3]: the values that will populate the new column.
Focus on the countries DataFrame and add a new column named 'population', which represents the populations of countries, right after the first column ('country').
12345678import pandas as pd countries_data = {'country' : ['Thailand', 'Philippines', 'Monaco', 'Malta', 'Sweden', 'Paraguay', 'Latvia'], 'continent' : ['Asia', 'Asia', 'Europe', 'Europe', 'Europe', 'South America', 'Europe'], 'capital':['Bangkok', 'Manila', 'Monaco', 'Valletta', 'Stockholm', 'Asuncion', 'Riga']} countries = pd.DataFrame(countries_data) countries.insert(1, 'population', [61399000, 75967000, 39244, 380200, 10380491, 5496000, 2424200]) print(countries)
Swipe to start coding
You are given a list named cars_data.
- Given this list, create a
DataFramenamedaudi_cars. - Insert a column named
'price'between the'year'and'fueltype'columns and populate this column with the following values:[12500, 16500, 16800, 17300, 13900].
Solution
Switch to desktop for real-world practiceContinue from where you are using one of the options belowThanks for your feedback!
single
