Thank you !
Great answer. This is why I ask these questions here !
LG
On Fri, May 29, 2020 at 5:51 PM Suvayu Ali <fatkasuvayu+li...@gmail.com>
wrote:
> On Fri, May 29, 2020 at 11:39 PM linux guy <linuxguy...@gmail.com> 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@lists.fedoraproject.org
> To unsubscribe send an email to users-le...@lists.fedoraproject.org
> 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@lists.fedoraproject.org
>
_______________________________________________
users mailing list -- users@lists.fedoraproject.org
To unsubscribe send an email to users-le...@lists.fedoraproject.org
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@lists.fedoraproject.org
