clarence | Clarence feaures | Interpreter library

I have a dataframe that has a weird format that I am having difficulty formatting it to a desired format. I just need the columns first_name, last_name, domain, Email, Verification and status but am not sure how to remove it when it is in this format.

I have a question that sorts data from a car report of txt file.

The question is: How do I listed cars sorted by their MAKE (Ford, Chevy ..etc). They only need the MAKE to be sorted so they can be all FORD cars under each other, then Chevy, DODGE .. so on and so forth like this:

And this is what I have so far:

Here's my source code:

I have a Java question that deals with reading the txt file and pulling data from it.

It's a bunch of used cars stored in a txt report file. They have several different lots that they sell from. The lots are identified by the 5 digit zip code followed by a zip code extension at the beginning of each record. They would like a report that lists all cars sold from all lots. This is what I come up with:

They would like the report to list 30 cars per page, on the report. Each page is to have headings and a page number. Like this:

My question is how do I list 30 cars per page instead of all together (Each page 30 cars with headings and page #)?

Here's my source code:

following are my files for html, .ts and json . As json data was very extensive therefore i have just added a few states and their cities. my 1st dropdown is showing all states. Now I want to match my 1st dropdown's selected value of state with a key "state" in "cities" object in my json file so i can populate 2nd dropdown with cities relevant to that state. and I want to do this in function "getCitiesForSelectedState". please help me find solution for this.

//.ts file

My calculations are correct. But the output file's ONLY first calculated record becomes as BLANK and affects all the records.

In the output file [A5-SalaryReport-5A.out], you may see the first record's position comes BLANK.

THIS IS MY INPUT FILE [A5.dat]

I'm using SQL server management studio, and need to find which manager has the most employees.

I want the output to show John Wick as highest

I am almost done with an exercise but need help with the last bit. The premise is to have only a clicked article to be shown out of a list of four articles. I can hide all but the first article and get the heading to show when the respective article is clicked but I'm having trouble with the code to get the actual article to show. Here is an HTML snippet (let me know if you need more):

I need to read a .txt file line by line and store each line to an array. Each array has 3 elements, empId, name, salary, which are fields of SalariedEmployee class. My code has a NumberFormatException, I have no idea which step goes wrong. Any hint or help would be appreciated. Thanks. Please don't close my question, I'm a beginner of Java.

Exception message:

Desired Behaviour

Be able to retrieve City, State (Region) and Country values upon selecting a place from autocomplete search box results.

Actual Behaviour

It seems each Place may have a different number of values in its address_components array, so it's not possible to directly reference City, State and Country by their position in the array.

Question

Is there an established convention for easily getting consistent City, State and Country values from Places?

I started creating a nested loop to check the types values within the address_components array values, but it felt like too much work, and also it seems that values in the types array do not need to be unique, eg type > political can appear more than once in an address_components array.

What I've Tried

Relevant Code