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.
From SQL Server, to Azure, to Fabric: My Microsoft Data and Analytics journey
There is always something new in the Microsoft space, and Fabric is the latest game-changing update to impact the world of analytics.
Read more
Predicting and monitoring air quality
How we delivered an end-to-end forecasting solution for predicting the values of the air pollutant, PM2.5, in Newcastle.
Read more
Turbocharging Power BI performance
How external tools can improve the performance of Power BI semantic models.
Read more
