We’re keen advocates of the CSV on the Web (CSVW) model for tabular data. Previous posts on the blog have explained why and how to publish CSVW data.
We’ve also been thinking about consuming CSVW. We believe the standard can be particularly useful for data analysts. The tabular metadata can help to reduce the amount of manual work needed to parse and prepare data before it can be used in analysis. You can use it to find tables, identify column names and cast values to the correct types.
To this end, we’re delighted to announce a new R package published on CRAN called csvwr. You can get started with the short introduction which explains how to read and write CSVW in R.
We’d be delighted to hear how you get on. You can provide feedback and follow development on the csvwr github repository.
Our recent blog posts
Transformation is for everyone. We love sharing our thoughts, approaches, learning and research all gained from the work we do.
Turbocharging Power BI performance
How external tools can improve the performance of Power BI semantic models.
Read more
Hash keys, the unsung hero of data warehousing - Part 2
We delve into the examples and benefits of using hash keys to improve data warehousing solutions
Read more
Hash keys, the unsung hero of data warehousing - Part 1
In our first piece on the subject, we examine what hash keys are and how they can have an impact on your data warehouse solutions.
Read more