I need to find some Java tools that work similar to pandas in Python. pandas is a tool that provides high-performance, easy-to-use data structures and data analysis tools.
I have a few .csv files in AWS S3 that store large amounts of data (like 80 MB). What I want to achieve is using Java, I want to make some data analysis on it, like joining data, processing it, merging together different columns from .csv file. I know that it’s easy to achieve in Python with the pandas library. But not sure, how hard is it to do in Java?
pandas, for example, has data structures called DataFrames, which is great for my use-case.
Note: I cannot use Python for certain reasons, because this goal that I'm trying to achieve should be as part of our DataPipeline, which is already written in Java.