On Fri, May 29, 2020 at 11:39 PM linux guy <linuxguy123@xxxxxxxxx> wrote:
>
> Hi people.
>
> I have a huge CSV spreadsheet. I need to do a bunch of light duty data manipulation. Sort, total, export, that sort of thing. I could almost do it in the spreadsheet, but it would be too much copy/paste and the combinations of data I want to get out are exhaustive.
>
> I'm thinking of importing it into Firebird. I'm looking for a good GUI SQL client.
>
> Thoughts/ advice ?
>
> TOar ?
> DBEaver ?
Good GUI client, you could use it with SQLite and get the job done effectively
> Something else ? (Python?)
I prefer Python, particularly Pandas.
import pandas as pd
df = pd.read_csv("/path/to/giant.csv", <other options, but usually
not required>)
Then you can use the Pandas API to do whatever you like really (see
the official docs, very thorough, and easy to understand, full of
examples). If you prefer an SQL interface, you can try installing
`sqldf` alongside pandas, and run SQL inside the pandas DataFrame.
HTH,
--
Suvayu
Open source is the future. It sets us free.
_______________________________________________
users mailing list -- users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe send an email to users-leave@xxxxxxxxxxxxxxxxxxxxxxx
Fedora Code of Conduct: https://docs.fedoraproject.org/en-US/project/code-of-conduct/
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: https://lists.fedoraproject.org/archives/list/users@xxxxxxxxxxxxxxxxxxxxxxx
