Dealing with data. Filter, edit, delete, and more

How can I edit a dataset?

Datasets can be modified by selecting the Edit option at the top of the dataset view. Within the metadata section you can change the name, add/modify a description, tags, source and reference links.

How can I delete a dataset?

To delete a dataset, select the upper right Edit button of the dataset view and go to the bottom. Once there, passing the Metadata section, it can be deleted by pressing Delete this dataset in the Danger zone. Before deleting it, in Confirmation you have to write the name of the dataset to be deleted and pressing Delete will permanently delete it.

How can I move the dataset to another repository?

[COMPLETE]

How can I Transform the data of a dataset?

The transformations are the results of processing a variable using the Pipelines tool. It includes processes such as changes in the unit of measurement of the data, seasonal adjustments, filters, changes and frequencies, and more. To see more information about the pipelines and available transformations, click here.

[PIPELINES]

What is a “Tag”?

A tag or label is a word associated with the content that includes it, which allows the information to be categorized into different topics and facilitates subsequent searches.

What are the “Activity” messages that appear to the right of a dataset?

When entering a dataset, the Activity column on the right shows the status of the actions performed on the dataset and the associated pipeline. Four stages may appear:

  • Updated shows when was the last time a new data was added
  • Processed means that the dataset finished running
  • Processing assumes that you are loading the new information
  • Error when something failed in the process.

What does the “Sync Now” button do?

By clicking on Sync Now the user calls the process that automatically fetches the data. If there is new data in the original source it should be updated within a few seconds.

Can I filter data before downloading it?

From the dataset view, you can download all or part of the data. To download all the data, you simply need to click on Download and select the download format. By default, the data is downloaded as shown in the Data excerpt, but if you wish, you can download it by reversing rows by columns, that is, where the dates and entities are transposed as columns.

To filter information, you can do so by clicking Filter. You can filter variables, transformations, and the period it covers.

Luciano Cohan

Written by

Luciano Cohan

Co-Fundador de Alphacast. Ex Subsecretario de Programación Macroeconómica. Data Science. Creando una plataforma para el trabajo colaborativo en economías

Related insights

  • Read more...

    Creating tables with Pipelines

    Our Pipelines feature is a powerful tool which allows report automatization. Let's say, for example, that you want to create an insight which shows dynamics of Argentina FX rates and a table with latest data, including percent changes. Wait! Did you just say "a table"!?

    **With Pipelines you can transform datasets in multiple ways (for

  • Read more...

    How can I create a Portfolio Tear-Sheet?

    Alphacast pipelines can be used to design and test portfolio and trading strategies. With the "Porfolio Analysis" Step on the pipeline editor you can create tear-sheets from daily returns and also dynamic rolling stats for different timeframes.

    image.png

    Step 1. Load the data and calculate a daily return variable.

    You can