Delete all but one column of pandas dataframe?

Delete all but one column of pandas dataframe?

To delete all columns except one in a pandas DataFrame, you can use the drop method with the column names you want to remove. Here's an example:

import pandas as pd # Sample DataFrame data = {'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]} df = pd.DataFrame(data) # Keep only one column (e.g., 'A') and drop the rest columns_to_keep = ['A'] df = df[columns_to_keep] print(df)

In this example, we first create a sample DataFrame df with columns 'A', 'B', and 'C'. To keep only column 'A' and delete the rest, we specify 'A' in the columns_to_keep list and then assign the filtered DataFrame back to df. The resulting DataFrame will contain only the 'A' column.

If you want to keep a column other than 'A', simply replace 'A' with the name of the column you want to retain in the columns_to_keep list.

Examples

  1. Delete all but one column of Pandas DataFrame using indexing:

    • Description: Remove all columns except one from a Pandas DataFrame by indexing.
    import pandas as pd # Create a DataFrame df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}) # Keep only column 'A' df = df[['A']]

  2. Drop all but one column from Pandas DataFrame using drop() method:

    • Description: Use the drop() method to eliminate all columns except the specified one from a Pandas DataFrame.
    import pandas as pd # Create a DataFrame df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}) # Drop all columns except 'A' df.drop(columns=['B', 'C'], inplace=True)

  3. Remove all but one column from Pandas DataFrame with slice assignment:

    • Description: Use slice assignment to retain only one column in a Pandas DataFrame, discarding all others.
    import pandas as pd # Create a DataFrame df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}) # Keep only column 'A' df = df[['A']]

  4. Delete all but one column of Pandas DataFrame with loc accessor:

    • Description: Utilize the loc accessor to select and keep only one column in a Pandas DataFrame.
    import pandas as pd # Create a DataFrame df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}) # Keep only column 'A' df = df.loc[:, ['A']]

  5. Dropping all but one column of Pandas DataFrame with iloc accessor:

    • Description: Use the iloc accessor to remove all columns except one from a Pandas DataFrame.
    import pandas as pd # Create a DataFrame df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}) # Keep only column 'A' df = df.iloc[:, [0]]

  6. Remove all but one column from Pandas DataFrame by column index:

    • Description: Delete all columns except one from a Pandas DataFrame by specifying the index of the desired column.
    import pandas as pd # Create a DataFrame df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}) # Keep only column at index 0 ('A') df = df.iloc[:, [0]]

  7. Deleting all but one column of Pandas DataFrame with filter() method:

    • Description: Use the filter() method to retain only the specified column in a Pandas DataFrame, discarding all others.
    import pandas as pd # Create a DataFrame df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}) # Keep only column 'A' df = df.filter(['A'])

  8. Drop all but one column from Pandas DataFrame using reindex() method:

    • Description: Use the reindex() method to select and keep only one column in a Pandas DataFrame.
    import pandas as pd # Create a DataFrame df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}) # Keep only column 'A' df = df.reindex(columns=['A'])

  9. Removing all but one column of Pandas DataFrame using pop() method:

    • Description: Utilize the pop() method to remove all columns except the specified one from a Pandas DataFrame.
    import pandas as pd # Create a DataFrame df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}) # Keep only column 'A' df.pop('A')

  10. Delete all but one column of Pandas DataFrame with drop() method and axis parameter:

    • Description: Use the drop() method with the axis parameter set to 1 to remove all columns except the specified one from a Pandas DataFrame.
    import pandas as pd # Create a DataFrame df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]}) # Keep only column 'A' df.drop(['B', 'C'], axis=1, inplace=True)

More Tags

mapfragment homekit typescript getstring oracle12c java-11 entities fetch-api ng-class spotify

More Python Questions

More Pregnancy Calculators

More Dog Calculators

More Stoichiometry Calculators

More Animal pregnancy Calculators