{"repo":"caerbannogwhite/preludio","free":true,"listed":false,"github":"https://github.com/caerbannogwhite/preludio","clone":"git clone https://github.com/caerbannogwhite/preludio.git","description":"Preludio is a data wrangling language based on PRQL and written in Go. 🎭","language":"Go","stars":14,"topics":["data","data-engineering","golang","language","manipulation","sql","dplyr","csv","go","prql"],"license":"MIT","category":"databases-storage","readme_excerpt":"🎭 Preludio A PRQL based data transformation language Preludio is a data transformation language based on PRQL. It is a language that allows you to transform and manipulate data in a simple and intuitive way, batteries included. No libraries or external dependencies are required to run the language. Examples Read and clean up a CSV file, then store the result in a variable called clean : Derive new columns and write the result to a CSV file: Create a new table by joining two tables: Features - [x] Arithmetic and logical operators - [x] Read and write CSV files - [x] Derive new columns - [x] Select columns - [x] Filter rows - [x] Sort rows - [x] Join tables - [ ] Group by and aggregate Installation To run it, you need to have Go installed. Once you have Go, you can clone this repository. To run the program, you can use the following command: Future Features - [x] Move to Gandalff library - [ ] Add statistical functions - [ ] Add support for Excel files - [ ] Add support for XPT files - [ ] Add support for SAS7BDAT files - [ ] Add support for SPSS files - [ ] Add date/time data types - [ ] Database connections (SQL, MongoDB, etc.) - [ ] VS Code extension In case the language becomes quite successful, I will consider adding: - [ ] Text editor/Ide (in browser and app) - [ ] Plots (https://github.com/gonum/plot) - [ ] Interactive plots and tables - [ ] Integration with other languages (Python, R, etc.) - [ ] Integration with other tools (Jupyter, etc.) - [ ] Integration with OpenA","default_branch":null,"files":null,"tree":[],"storefront":"/r/caerbannogwhite","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/caerbannogwhite/preludio/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}