pvt | PHP extension for web-application dynamic analysis | Code Analyzer library

I hope someone would be able to help, I am fairly new to PostgreSQL, not to mention json conversions thereof.

Currently I have written a cursor that populates the data from different tables in postgresql into a "temp" table (using json_agg) and then selecting the columns from the temp table to get the result set I need. This works well (for the time being), problem is I cannot find how to show the data the way the client wants.

The temp select that I am running is:

...

I have a vector of text data (news data). I am trying to scan the text for any money amount and the text surrounding this amount. I managed this with the first element of my vector but struggle with using a loop and list to repeat the process for all data. I use str_extract_currencies from stringr which does a good job in detecting numbers. It may be possible with regular expressions, but I don't know how.

...

I am having trouble creating pivot table that follows the schema described below. For example, with the following table (not all records are shown here):

Route Bus_Fare_Payment_Method Total_Annual_Household_Income Route 1 10-Ride Pass $15K To $19K Route 1 10-Ride Pass $15K To $19K Route 1 10-Ride Pass $25K To $29K Route 1 10-Ride Pass $60K Or More Route 1 Regular Cash Fare Under $10K Route 1 Regular Cash Fare Under $10K Route 1 Regular Cash Fare Under $10K Route 1 Regular Cash Fare Under $10K Route 1 Regular Cash Fare Under $10K Route 1 Regular Cash Fare Under $10K Route 1 Regular Cash Fare Under $10K Route 1 Regular Cash Fare Under $10K Route 10 10-Ride Pass $30K To $39K Route 10 31-Day Adult $10K To $14K Route 10 31-Day Adult $10K To $14K Route 10 31-Day Adult $10K To $14K Route 10 31-Day Adult $10K To $14K Route 10 31-Day Adult $15K To $19K Route 10 31-Day Adult $20K To $24K Route 10 31-Day Adult $20K To $24K Route 10 31-Day Adult $20K To $24K Route 10 31-Day Adult $20K To $24K Route 101 All Day Pass Reduced Under $10K Route 101 Other Under $10K Route 101 Reduced Fare $10K To $14K Route 101 Reduced Fare $25K To $29K Route 101 Reduced Fare $30K To $39K Route 101 Reduced Fare $40K To $49K Route 101 Reduced Fare $60K Or More Route 101 Reduced Fare $60K Or More Route 101 Reduced Fare $60K Or More Route 101 Reduced Fare Under $10K Route 101 Reduced Fare Under $10K Route 101 Reduced Fare Under $10K Route 101 Regular Cash Fare $10K To $14K Route 101 Regular Cash Fare $10K To $14K Route 101 Regular Cash Fare $10K To $14K Route 101 Regular Cash Fare $10K To $14K

I would like to produce the following table:

Route Bus_Fare_Payment_Method $10K To $14K $15K To $19K $20K To $24K $25K To $29K $30K To $39K $40K To $49K $60K Or More Under $10K Route 1 10-Ride Pass 2 1 1 Route 1 31-Day Adult Route 1 All Day Pass Reduced Route 1 Other Route 1 Reduced Fare Route 1 Regular Cash Fare 8 Route 10 10-Ride Pass 1 Route 10 31-Day Adult 4 1 4 Route 10 All Day Pass Reduced Route 10 Other Route 10 Reduced Fare Route 10 Regular Cash Fare Route 101 10-Ride Pass Route 101 31-Day Adult Route 101 All Day Pass Reduced 1 Route 101 Other 1 Route 101 Reduced Fare 1 1 1 1 3 3 Route 101 Regular Cash Fare 4

I am able to create the following table with the query included below, but I am missing the Route field which I need as part of my output (as shown above).

...

I have an npm package hosted on github. It's working fine while working on the local machine. But it's not installing while the docker build process.

Dockerfile

...

I have been stuck on trying to export in the format needed for this script for a month now. I can't figure out how to get it to export these variables in two separate loops into a single .csv file. We are given a .csv that contains staging_input and staging_location fields that both contain file locations on the network. We need to compare these two to make sure they are the same file count and size. I created a ForEach-Object loop for each of these fields and this gives me the desired output but I am unable to export-csv at the end of each loop into a single .csv.

Desired final output

Current output

...

How do you sum up the 'Fee' column and make unique ControlNo in the below example?

Code sample:

...

How would I pivot based on multiple dependent columns instead of a single dependent column?

...

How to display DietName which is under Data? I can display the item which is under PartnerData[] But what is the syntax just to display DietName?

...

How would I convert rows into columns? In this case, taking the columns of Reason and Weight and expanding the values where more columns are created?

The column Reason will only have four values (whereas the field may be blank too): Natural, Emissions, and Humans.

Input Table Example:

...