oslo | A simple Visual Studio Code Theme creator

I am having trouble with something i thought it will be simple.

I have an array of nested arrays with strings.

...

I encountered this problem while trying to arrange for total_number of boys and girls, but there was top places for boys that were not in the top 20 for girls. The visualization did not show an even representation of the sample because the top places of the girls are not the top places of the boys and vice versa (though they do visit similar places, just not in vast numbers).

place Category2 total_number Andorra la Vella boy 66394 Yerevan boy 33539 Vienna boy 29757 Baku girl 24615 Minsk girl 23847 Brussels girl 23691 Sarajevo boy 23285 Sofia boy 21309 Oslo girl 20982 Zagreb boy 19885

I have arranged by the total_number descending, used head(20) and attempted to plot it. This did not look good because of empty spaces and out of order with respect to the boys and girls (category 2). I want to arrange for the top 20 of the data set, but I want the arrangement of total_number to alternate between girls and boys of Category2 to show an equal representation and no blanks in the top 20 of the visualization. How do I do this?

...

Basically I have a table called cities which looks like this:

...

I have a 2 tables and one view which I want to find which pairs are duplicate:

...

I would like to add a suffix to strings in one column when a condition is met in another column. If a value is present in "Market" column, "Symbol" column corresponding value is updated to include current ticker but I would like to add a suffix to it representing its market place. I guess I could create multiple masks and change multiple values with multiple lines of codes for each value but I was wondering if there exist a more elegant way of doing this in one operation.

This is what I tried :

conditions = [ (df['Market'].str.contains("Oslo")), (df['Market'].str.contains("Paris")), (df['Market'].str.contains("Amsterdam")), (df['Market'].str.contains("Brussels")), (df['Market'].str.contains("Dublin")) ] values = [str+'.OL', str+'.PA', str+'.AS', str+'.BR', str+'.IR'] df['Symbol'] = np.select(conditions, values) print(df)

I get an error :

unsupported operand type(s) for +: 'type' and 'str'

any help welcome

added after KingOtto's answer...

the data frame :

...

I have these 2 tables which I would like to query:

...

I would like to get results from the fields (path) in table URL where the last directory in the path field from URL table contains at least two matching words from the same row in the Locations table.

Table URL

...

I would like to create a func that gets several pandas columns and make extra string manipulation to create another column. The string maipulatioins has to be dependent on some other string constants that are sent to the function.

...

I'm modifying a CSS template based on bootstrap, in order to obtain a responsive simple website.

The page provides a list of events. Since show_date and show_shop have fixed width, when the website is opened on a smartphone (smaller screen) the class flex-row allows the show_name and show_location to be disposed in column to save space.

The problem is that when the text in show_name and show_location is too long, the text wrap out of the box in vertical.

How can I force the text in show_name and show_location to use only a single line (one for each one), truncating the text with ...?

I tried overflow: hidden with text-overflow: ellipsis but it doesn't work (I think due to the flex width of the div).

Thanks for help.

...