barista | project barista - open source license

I want to create two new columns in job_transitions_sample.csv and add the wage data from wage_data_sample.csv for both Title 1 and Title 2:

job_transitions_sample.csv:

I've made a Select Query with multiple Tables using Joins. In the database, I have some data that have the same id but 1 or 2 columns have different values. When I run the query I get (for example) 2 objects that have the same data( for the first 3 columns) except a single column that has a different value. Now in the database, I have multiple of these, so I would get 10-20 objects and some of them are "duplicates" with the only difference being one of these columns. Is it possible to make a query that brings me this data without the "duplicates". So the columns that have the same value be the same but the column that the data is different be in an array (so have all 'different' data in the same place).

Example:

#using spread of data to determine (descriptive) position within the dataset

code is the following:

On my website I have 3 types of employees

• barista
• barista01
• security and I would like to hide the barista01 option but leave the others as they are (please refere to the picture).

When i try to use $("div:contains('barista01')").parent('div').hide(); I get a full black window hiding everything inside. Is there anyway how to fix this?

Thank you in advanced enter image description here

I have added a h1 heading at the top of a few of my pages on my website but they do not appear at I run when I run it. Below I have my HTML for one of the pages, a screen shot of the page, as well as my CSS. It is supposed to go below the nav bar before the content of the page and be centered.

HTML

I'm trying to use Beautiful Soup to extract the title of a job. The title in the span tag is the same as the text. Eg: text is 'Barista' but so is the title. So far I've been using .findall but idk how it can work for this.

Sample html:

I am having an issue trying to move menus to the right hand side of the page. I tried using a float:right but it changes the order of the menus and I have been trying to add a flex end but doesn't seem to work, not sure if I'm calling on the wrong element.

If you view the screenshot below, I want the 4 footer menus (account, shop, about and barista coffee) to be moved to the right of this footer. The column that has the logo, social icons and address should remain where it is. How do I move it?

Screenshot:

HTML (I commented where the four menus are - see shift to right comment):

Apologies for pasting a big html but I have been struggling to fix the css and it will take too much work to try and shorten the code, so instead I want to show the full screenshot and the code behind it.

If you look at the screenshot, the whole content block within the footer is closer to the left edge. I want the whole content block to be in the centre but don't know how to do it.

Basic CSS:

I have this simple react component for my switch button , all want is to set my true and false active state when I click or toggle it , maybe display a console that barista or cafe owner is active

[Use Link inside my code to view Switch button gif][1]