Modify DataFrames
This document will show how to modify Pandas DataFrames with Visual Python.

To Modify Pandas DataFrames

  1. 1.
    Click on the Frame app.
  2. 2.
    Select the DataFrame to modify.
Multiple column/row selection allowed: (Ctrl + Select)

Add a new column

  1. 1.
    Click on the Add Column button or + button at the top-right corner of the table.
  2. 2.
    Name a column & set options.
  3. 3.
    Click OK.

Replace column values

  1. 1.
    Right-click on the column's header.
  2. 2.
    Click Replace.
  3. 3.
    Set options, and then click OK.

Rename columns

  1. 1.
    Right-click on the column's header.
  2. 2.
    Click Rename.
  3. 3.
    Provide new names for all columns.
  4. 4.
    Click OK.

Delete columns/rows

  1. 1.
    Right-click on the column/row's header.
  2. 2.
    Click Drop - Drop.

Remove missing values

  1. 1.
    Right-click on the column's header.
  2. 2.
    Click Drop - Drop NA.

Remove duplicates

  1. 1.
    Right-click on the column's header.
  2. 2.
    Click Drop - Drop Duplicates.