Skip to content

Mission 7 - Simple data editing

Learning Objective

In this mission we learn how to do basic manipulations of the data such as inserting new rows, columns, editing cells, renaming columns, etc.

Data

Please download the required dataset we will use: business_transaction.xlsx

Steps

First open the data to edit.

Editing a cell

Double click on the cell and edit the value.

Note

When entering the new value make sure that it's compatible with the column type. For example if it's a decimal column you cannot enter text.

Inserting a row

Right click anywhere in the row and select either Insert a new row after or before.

Inserting a column

Right click on a column header and select either Insert a new column before or after.

Deleting one or multiple rows

Select either one or multiple rows you wish to delete by dragging the mouse over the row numbering.
Right click inside the selection, and press delete selected rows.

Deleting one or multiple columns

Select either one or multiple columns by holding and dragging the mouse over the headers
Right click inside the selection, and press delete selected columns.

Well done! Now let's move on to the next mission!