Re: [Jprogramming] J and data analysis/relational algebra

2014-12-07 Thread 'Pascal Jasmin' via Programming
select where u is (] #~ u) fromthis joins can be a bit tricky (though as Chris mentioned you can consider jd or jdb). You can also look up inverted tables on wiki. Some extra options in J when working with data is to separate your tables by data type so that you have a lot of 1 to 1 relation

Re: [Jprogramming] J and data analysis/relational algebra

2014-12-07 Thread chris burke
It really depends on your data and queries. You could either do these directly in J or using the Jd database (which has a fast csv reader and SQL-like queries). Could you give us some simple examples? On Sun, Dec 7, 2014 at 6:57 PM, Ryan wrote: > I appreciate how helpful this forum has been so

[Jprogramming] J and data analysis/relational algebra

2014-12-07 Thread Ryan
I appreciate how helpful this forum has been so far so I'd thought I'd ask another question. Essentially, can someone point me to how J users perform the basic data manipulation operations that you can do, for example, using R's dplyr or SQL queries? Specifically, I want to be able to (mainly o