Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

Re: Newbie question

by swl (Parson)
on Oct 19, 2021 at 21:47 UTC ( [id://11137751] : note . print w/replies, xml ) Need Help??

in reply to Newbie question

hippo has answered #2, but you could also have a look at Data::Frame for a general structure. It does not do things like joins and the API is marked as experimental, but it might still be interesting.

Data::Frame uses PDL for the numeric data, which is something else you could look at if you do not have mixed strings and numbers (but then you would probably be asking about numpy equivalents).

It also has a high number of fails on cpan testers, but those seem to have been cleared up with recent releases of PDL.

Replies are listed 'Best First'.
Re^2: Newbie question
by SpaceCowboy (Acolyte) on Oct 19, 2021 at 21:51 UTC
    Thanks for your response. I am getting data from multiple databases. I needed to extract them, store them in a variable, drop a few columns, rename a few, calculate bunch of fields and prepare a final dataset. IS this still possible with Data::Frame and PDL as a whole?

      Possibly, but have a look at the documentation. It's probably better in the long run to work directly with the database, as per hippo's suggestion in 11137712.

      One place to start would be DBI, but stated with the caveat that I've never used it or interacted with databases via perl. However, many of the other monks have and could give you good advice.

      If PDL processing is still desired, there is PDL::IO::DBI to bring in data from RDBMS.