CSV files

Upload CSV files as a data source

CalcTree provides support for using CSV files in your calculation works. There are two ways to use CSV files in your work:

• Through a Python script

• Adding the CSV file as a Source

Using CSV files through Python

You can upload any file type to a CalcTree page, and the uploaded files will be available to Python scripts.

For example, click on File Upload to select a CSV file from your local drive to upload to CalTree. Use the sample CSV file below. After uploading, the file appears on the right-hand panel, and is accessible to Python via ct.page_files['file_name'] . See exaple below:

334B

Load_Pattern_Definitions.csv

import pandas as pd

def read_csv(csv):
    return pd.read_csv(ct.page_files[csv]).astype('object').fillna("")
    
load_patterns_df = read_csv("Load_Pattern_Definitions.csv")

CSV files as calculation sources

Coming soon!

CSV parameters are among next items on our roadmap. Please follow our product roadmap items and status here and let us know what you think!

Meanwhile, you can upload any type of file, including CSV files, and use them in Python scripts! To learn more scroll up on this page to #csv-files-through-python