I am trying to sort a csv file containing 3 values. The first one is the one that matters. It contains many times the number 1, 2, 3, 4 etc etc. But each number doesnt appear the same number of times as the other number. So, i wanna sort the csv file from its 1st column, from less times of appearance of each number to the highest number of appearces.
for example - i dont mention the 2nd and 3rd row because i want it sorted via the 1st column
Aside from writing those amazing queries, another way of sorting the columns of CSV files is to utilize a Relational Database Management System(RDBMS), such as Acho.
Upload your CSV as a Resource
You can upload your CSV file using Single CSV or Multiple CSV. Please note that all the column names, column data types, and the number of columns need to be the same if you are uploading multiple CSV files as MCSV.
If the CSV upload is not successful, then just try out the Safe mode, it can automatically turn all the columns into String data type.
Add the resource into a project
After uploading the CSV, just add the CSV file into a project, and go to the workspace to view the table. In order to sort the column, you can simply click the Sort button under Column Dropdown to sort the column you need.