3 ms·
My main issue with them is that they often aren't reproducible as the data transformations aren't logged. As a computational biologist I often deal with spreads
by jhbadger 7y ago
My main issue with them is that they often aren't reproducible as the data transformations aren't logged. As a computational biologist I often deal with spreadsheets that experimentalists give me. I have no idea how the data were transformed from the raw data, and often the experimentalists themselves can't remember either. That's why I infinitely prefer real programming languages for use in data manipulation -- you can look at the code.
- froindt 7y agoPowerQuery is integrated into excel, gives a visual editing platform (not purely code), and is quite powerful in terms of linking up to any datasource, manipulating data, and giving you the output you need. All the steps are listed on the right side, and you can click back to any previous step in the transformation. It's not super popular, but it does serve as a nice middle ground for people in the space who aren't strong in coding.