For example, in Python
All you have to do then is
at the top of your script and you’re good to go, with some serious tools at your fingertips, e.g.
gives you a 100x4 dataframe with the column names of your choice filled with random integers between 0 and 100. Not bad, eh?
So what about PHP?
Well, PHP has its own package manager, Composer, which is no slouch either.
In the remainder of the post, we are going to go through the process of taking a CSV, parsing the data into memory, reversing the order of the data and then outputting a new CSV with the data in the new reversed order. Moreover, we are going to see what third-party libraries PHP has to help do this. Now, anyone who has tried doing this in native PHP has probably noticed it’s a bit of a faff. Hopefully, you’ll find the method below simpler.
First, you need to install Composer, which is just an executable binary, nice and lightweight. The official site has clear instructions on how to do this. We’ll assume in this post that you’re on a Unixy system and have the Composer executable in your PATH variable.
I’m led to believe that most PHP libraries worth their salt can be found on Packagist. Let’s hop on over there and see what we get if we type in “csv”. The first match that comes up is league/csv. Looks pretty slick from the examples, and documentation seems good, too.
Let’s make a root directory for our task
The last line downloads the package into your project root and does some configuration. You should see two files, composer.json and composer.lock, as well as a vendor directory (this is where the package’s source files are). Let’s suppose your CSV is in the project root, and that the project root is the current working directory. Fire up your editor and type in something like
Save your script into the project root and give it executable permissions
and presto, you should see a new CSV file with the rows reversed in the project root.