noir | Noir is a domain specific language for zero knowledge proofs | Cryptography library

I have a DataFrame like this in python

I have a document that looks like this

Lets say i have a table videogames and I want to find the number of games released in in intervals of 3 years starting from year 1997.

videogames

From the table, the expected output should be Year (1997-1999) = 3, Year (2000-2002) = 2, Year(2003 - 2005) = 2, Year(2006-2008) = 1, Year (2009 - 2011 ) = 1 and Year (2012-2014)= 2

This is my attempt at solving the code:

I have a form with "Does this case have IR number?"
If yes, show fields. If no, hide and show others.

I am using

• validate() function.
• old() to keep data after failed form submission, aka validate() error messages.
• JQuery show/hide for the fields.

For the radio input, I used old() like this:

I'm looking for help I'm trying to get some data of json file from an api that I'm using for student project ( I'm very beginner on API stuff).

I'm at the beginning of the project and they asked me to get all of the json file data on the homepage with all informations associated with :

Those are the data that I extract for the API

It's works fine and when the user click on one of the item it's show the same information but only the for the one clicked and this is where I'm stuck.

When I click on an item each of them have an id related to a link showing their own id :

The small code use through a loop to get all items id

So I create another js file for the product page where I have to implement them only with Javascript Vanilla and this is what I've tried :

I want to create movie node and create a relation between movie and genre from a csv

CSV file: id|title|release|action|adventure|animation|childrens|comedy|crime|documentary|drama|fantasy|film-Noir|horror|musical|mystery|romance|sci-Fi|thriller|war|western 1|Toy Story (1995)|01-Jan-1995|0|0|1|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0 2|GoldenEye (1995)|01-Jan-1995|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0 3|Four Rooms (1995)|01-Jan-1995|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0

My cypher query

i downloaded imdb database and while i was able to import it into mysql, i coulden't put the genre column datatype to "SET", even tho imdb only has 21 genre's for movies, when i imported the data i set the genre data type to VARCHAR(255), and i can not change it to SET, is it possible? here's what i tried:

ALTER TABLE movies MODIFY genre SET('Drama', 'Comedy', 'Action', 'Crime', 'Romance', 'Thriller', 'Adventure', 'Horror', 'Mystery', 'Fantasy', 'Sci-Fi', 'Biography', 'Family', 'Animation', 'Music', 'History', 'War', 'Sport', 'Musical', 'Western', 'Film-Noir') NOT NULL;

and i get the error code 1265 "Data truncated for column 'genre' at row 2", I'm guessing that's because row 2 has more than only one genre, but i thought that's the difference between ENUM data type in SET, am i missing something?

I have this array here let's call it $_products, my goal is to remove the array based on the key value of "activationdate" if it's greater than today's date.

I have a dataset, where I need to find top 2 average rated movies for each genre. With the given layout of data, how can I achieve it? Can someone please help me understand a workaround?

In order to simplify it, I have created new columns which separates values from 'genres' into unique genres and assigned values 1 and 0 to it. So, the group by will be based on these new unique genres and not the 'genres' column. For example, if I filter on the column 'Comedy' to 1, the average rating for title 'abc', 'pqr','ghi', and 'mno' are 3.75, 2.9, 2.25, and 3.12 respectively. So, the top 2 movies based on the average rating for Comedy genre will be abc and mno. Similar logic will be followed for other unique genres.

My original dataset is very similar to the sample dataset below: