Create new table

You might want to study only high-value transactions, isolate a particular country, or build a new table from scratch. In this section, we learn how to create a new table — either by selecting part of an existing one, or by writing out the data yourself.

Create a table from selected rows

Excel

In Excel, you filter or copy rows into a new sheet to work with a smaller set of data.

t0 Prompt

Make a new table with only the Brazil transactions

Create a table with rows where amount is over 10 million

Give me a new table with services transactions only

Code

The python code looks as follows:

brazil_transactions = transactions[transactions["Seller Country"] == "Brazil"]
brazil_transactions

Create a table from selected columns

Excel

In Excel, you highlight specific columns and copy them to a new worksheet.

t0 Prompt

Make a table with just the date, amount, and countries

Create a table of transaction types and amounts

Code

The python code looks as follows:

summary_transactions = transactions[["Date", "Amount", "Seller Country", "Buyer Country"]]
summary_transactions

Create a table manually

Excel

In Excel, you can type values directly into a new worksheet to build a table.

t0 Prompt

Create a new table with two rows and three columns

Make a custom table with date and amount

Code

The python code looks as follows:

new_table = pd.DataFrame([
    {"Date": "2025.5.1", "Amount": 5000000, "Currency": "USD"},
    {"Date": "2025.5.2", "Amount": 12000000, "Currency": "USD"},
])
new_table