Visual Python Documentation
Search…
GETTING STARTED
Welcome to Visual Python
How to install
Installing FAQ
TUTORIALS
Data Preparation
Data Exploration
Data Transformation
Modify DataFrames
Create Subsets
Group & Aggregate DataFrames
Combine DataFrames
Reshape DataFrames
RESOURCES
License
Brand Story
Community
Powered By
GitBook
Modify DataFrames
This document will show how to modify Pandas DataFrames with Visual Python.
To Modify Pandas DataFrames
1.
Click on the
Frame
app.
2.
Select the DataFrame to modify.
Multiple column/row selection allowed: (Ctrl + Select)
Add a new column
1.
Click on the
Add Column
button or
+
button at the top-right corner of the table.
2.
Name a column & set options.
3.
Click
OK
.
Replace column values
1.
Right-click on the column's header.
2.
Click
Replace
.
3.
Set options, and then click
OK
.
Rename columns
1.
Right-click on the column's header.
2.
Click
Rename
.
3.
Provide new names for all columns.
4.
Click
OK
.
Delete columns/rows
1.
Right-click on the column/row's header.
2.
Click
Drop - Drop
.
Remove missing values
1.
Right-click on the column's header.
2.
Click
Drop - Drop NA
.
Remove duplicates
1.
Right-click on the column's header.
2.
Click
Drop - Drop Duplicates
.
TUTORIALS - Previous
Data Transformation
Next
Create Subsets
Last modified
3mo ago
Copy link
Contents
To Modify Pandas DataFrames