To create a DataFrame in Julia:
using DataFrames
df = DataFrame(column_1 = ["value_1", "value_2", "value_3", ...],
column_2 = ["value_1", "value_2", "value_3", ...],
column_3 = ["value_1", "value_2", "value_3", ...],
...
)
Steps to Create a DataFrame in Julia from Scratch
Step 1: Install the DataFrames package
If you haven’t already done so, install the DataFrames package in Julia:
using Pkg
Pkg.add("DataFrames")
Step 2: Create a DataFrame in Julia
Let’s say that you have the following data, and your goal is to create a DataFrame based on that data:
product_id | product_name | price |
1 | Oven | 800 |
2 | Microwave | 250 |
3 | Dishwasher | 700 |
4 | Refrigerator | 1400 |
5 | Toaster | 120 |
Therefore, the complete code to create the DataFrame is:
using DataFrames
df = DataFrame(product_id = [1, 2, 3, 4, 5],
product_name = ["Oven", "Microwave", "Dishwasher", "Refrigerator", "Toaster"],
price = [800, 250, 700, 1400, 120]
)
print(df)
Step 3: Run the code in Julia
Run the code in Julia, and you’ll get the following DataFrame:
product_id | product_name | price |
1 | Oven | 800 |
2 | Microwave | 250 |
3 | Dishwasher | 700 |
4 | Refrigerator | 1400 |
5 | Toaster | 120 |
Calculate the maximum value using the DataFrames package
To calculate the maximum price using the DataFrames package:
using DataFrames
df = DataFrame(product_id = [1, 2, 3, 4, 5],
product_name = ["Oven", "Microwave", "Dishwasher", "Refrigerator", "Toaster"],
price = [800, 250, 700, 1400, 120]
)
max_value = maximum(df.price)
print(max_value)
Run the code and you’ll get the maximum price of 1400.