1

Linking a Data Source

Go to the My Files tab and click the “Upload File” button in the middle of the screen. Select Upload File to upload any type of file format — from CSV or Excel, to JSON or even multimedia files — for analysis or editing with Julius. Alternatively, you can select Share from URL to connect to a Google Sheet. Upon uploading or submitting, the data source should then appear in your data sources list.

2

Creating a Conversation

Once you have added your data source, you can head over to your conversations by clicking on “My Threads” to see existing conversations or create a new one by clicking on “New Chat”.

3

Setting the Active Data Source

Select an existing data source or add a new one by clicking the “Add file” button. Then, enter your initial instruction and press the Blue arrow button to send the message and kick off your first Chat.

4

Analyzing and Transforming Data

Once a data source is linked and a conversation started, you can ask Julius to analyze and transform the data using natural language commands. For example, you might say, “Show me the average sales by product category,” or “Sort the data by customer age.” Julius translates your commands into Python code and applies them to the data. You can perform any operation that is possible with a pandas dataframe, such as filtering, sorting, aggregating, performing regressions, and more.

5

Visualizing Data

You can prompt Julius to create visualizations from your data. You can request a variety of plot types, including but not limited to:

  • Bar plots: Useful for comparing quantities across categories. For example, “Show me a bar plot of sales by product category.”

  • Line plots: Useful for showing trends over time. For example, “Show me a line plot of sales over time.”

  • Histograms: Useful for showing the distribution of a variable. For example, “Show me a histogram of customer ages.”

  • Scatter plots: Useful for showing the relationship between two variables. For example, “Show me a scatter plot of age versus income.”

  • Pie charts: Useful for showing the proportion of categories. For example, “Show me a pie chart of sales by region.”

Julius will generate the requested plot and display it in the chat. You can then right click on the image and copy or save it if you wish to use the visualization in other contexts.

6

Exporting Data

If you’ve made changes to your data and want to export it, tell Julius to export the data. Provide a name for the export file and specify which data format you prefer — CSV or Excel file. A link will be generated in the chat, which will lead to a page with a download button for exporting the file.