Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lære Deleting a Row/Column | The Very First Steps
Pandas First Steps
course content

Kursinnhold

Pandas First Steps

Pandas First Steps

1. The Very First Steps
What is pandas? SeriesChallenge: Creating a SeriesDataFrameQuiz: Creating a SeriesQuiz: Creating a DataFrameAdding a New ColumnInserting a New ColumnDeleting a Row/Column Quiz: Matching the FunctionsWorking with ColumnsQuiz: Extracting Columnsiloc BasicsChallenge: Using iloc
2. Reading Files in Pandas
CSV FilesTXT FilesQuiz: Working with FilesQuiz: Accessing the Columns
3. Analyzing the Data
Viewing the DataQuiz: Using HeadQuiz: Head, Tail, and SampleExploring the DatasetColumn Names and Data TypesFinding Null ValuesQuiz: Identifying Null ValuesChallenge: Dropping Null ValuesChallenge: Filling Null ValuesQuiz: Null ValuesDescribing the Datamax() and min()Quiz: Statistical Operationssum() and count()Unique Values

book
Deleting a Row/Column

At times, certain columns may not provide valuable information, making it advantageous to remove them. The pandas library offers the drop() method for this purpose.

python
  • index: specifies the row indexes to be deleted (used when axis=0);
  • columns: identifies the column names to be deleted (used when axis=1);
  • axis: choose whether to remove labels from the rows (0) or columns (1). The default is 0.

We'll start by examining the DataFrame:


              
1234567

            
import pandas as pd 

countries_data = {'country' : ['Thailand', 'Philippines', 'Monaco', 'Malta', 'Sweden', 'Paraguay', 'Latvia'],
          'continent' : [None, None, 'Europe', None, 'Europe', None, 'Europe'],
          'capital':['Bangkok', 'Manila', 'Monaco', 'Valletta', 'Stockholm', 'Asuncion', 'Riga']}
countries = pd.DataFrame(countries_data)
print(countries)
copy

We notice that the 'continent' column contains numerous missing values, making it less informative. Consequently, we'll remove it.


              
12345678

            
import pandas

countries_data = {'country' : ['Thailand', 'Philippines', 'Monaco', 'Malta', 'Sweden', 'Paraguay', 'Latvia'],
          'continent' : [None, None, 'Europe', None, 'Europe', None, 'Europe'],
          'capital':['Bangkok', 'Manila', 'Monaco', 'Valletta', 'Stockholm', 'Asuncion', 'Riga']}
countries = pandas.DataFrame(countries_data)
countries = countries.drop(columns = ['continent'],axis=1)
print(countries)
copy
Oppgave

Swipe to start coding

You are given a DataFrame named audi_cars.

  • Remove the 'capital' column and save the resulting DataFrame in the audi_cars variable.

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 9
toggle bottom row

book
Deleting a Row/Column

At times, certain columns may not provide valuable information, making it advantageous to remove them. The pandas library offers the drop() method for this purpose.

python
  • index: specifies the row indexes to be deleted (used when axis=0);
  • columns: identifies the column names to be deleted (used when axis=1);
  • axis: choose whether to remove labels from the rows (0) or columns (1). The default is 0.

We'll start by examining the DataFrame:


              
1234567

            
import pandas as pd 

countries_data = {'country' : ['Thailand', 'Philippines', 'Monaco', 'Malta', 'Sweden', 'Paraguay', 'Latvia'],
          'continent' : [None, None, 'Europe', None, 'Europe', None, 'Europe'],
          'capital':['Bangkok', 'Manila', 'Monaco', 'Valletta', 'Stockholm', 'Asuncion', 'Riga']}
countries = pd.DataFrame(countries_data)
print(countries)
copy

We notice that the 'continent' column contains numerous missing values, making it less informative. Consequently, we'll remove it.


              
12345678

            
import pandas

countries_data = {'country' : ['Thailand', 'Philippines', 'Monaco', 'Malta', 'Sweden', 'Paraguay', 'Latvia'],
          'continent' : [None, None, 'Europe', None, 'Europe', None, 'Europe'],
          'capital':['Bangkok', 'Manila', 'Monaco', 'Valletta', 'Stockholm', 'Asuncion', 'Riga']}
countries = pandas.DataFrame(countries_data)
countries = countries.drop(columns = ['continent'],axis=1)
print(countries)
copy
Oppgave

Swipe to start coding

You are given a DataFrame named audi_cars.

  • Remove the 'capital' column and save the resulting DataFrame in the audi_cars variable.

Løsning

Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Alt var klart?

Hvordan kan vi forbedre det?

Takk for tilbakemeldingene dine!

Seksjon 1. Kapittel 9
Switch to desktopBytt til skrivebordet for virkelighetspraksisFortsett der du er med et av alternativene nedenfor
Vi beklager at noe gikk galt. Hva skjedde?
some-alt