oakland | Discussion for the Oakland chapter of NodeSchool | Collaboration library

I'm creating a dynamic SQL query and building some lookup tables on the fly in a CTE. The syntax I came up with is quite verbose and I wonder if there is a more compact way to express this. The lookup tables are CTEs created in code and can vary from query to query. Hope this example makes it clear:

I have a somewhat mobile responsive header, but there are some dropdown menus that I would like to keep flush to the edge of the header element regardless of changes in viewport size as the header adjusts.

I tried putting those dropdowns in their own element such as a div or section and adding all the same css from the individual selectors, but I did not make progress there.

I have a few questions about JSON in Pandas! I have gotten the data loaded into a dataframe and can search effectively with the query code below. Three questions I have:

1. How can I get the individual pieces of 'coord' (i.e. 'coord.lon')
2. How do I assign specific columns to variables in the code? (i.e. state = df.loc[df['name'] == city, ['state'])?
3. How can I add additional search terms? (i.e. df['name'] == city AND df['state'] == state)

Here is the code I have so far to pull the records I need:

query = df.loc[df['name'] == city, ['id', 'name', 'state', 'coord']]

Here is a sample of the JSON response I am trying to search:

I'm trying to grab some data from apartments.com but it seems as though BeautifulSoup alone will not capture the data because it's dynamic. After doing some research I've concluded Selenium is the way to get dynamic content to load.

However, even after using Selenium I'm not getting the relevant listings details.

This is what I have thus far:

I am trying to create an if conditional based on what city a user selects off the dropdown menu. It has presented itself a challenge because it's bulmas CSS dropdown which does not use and but all

For example, if I have a dataframe like this:

I am trying to automate a function call, so that I can produce one data frame by rotating in dependent variables such as x, y, and z and using various combinations of grouping variables such as year and race or separately, year, race, and city.

In more detail.

In my minimal example, I have three dependent variables, x,y,z. I also have several grouping variables. For each call, I need to count the number of 1’s. I also need to add a new column which contains string values which reflect the dependent variable that was used.

I was able to write a function that produces the counts when I specify the two grouping variables and the dependent variable. In the real problem, for each of about a dozen dependent variables, I will have to group in a number of different ways. I may have one, two, or three grouping variables. Outside of the function, I added the character column that gives information on what the variables were. I think that inside the function I should have a case_when()statement that says something like:

I've been through various posts on the same subject but I can't seem to be able to get to the data elements in my XML file.

Here is a snippet of my XML :

So I have the following program written in Java, which reads a text file's contents to a HashMap and takes in a year from the user to return what team won the World Series that year and how many times that team has won the World Series. I've successfully built the HashMap but I'm struggling with how I would make that HashMap accessible within the main driver method of the program (I understand why it's not accessible, I'm looking for how to access it). Right now, the instantiated HashMap in the main method is empty. I've been stuck on this for a while and can't seem to find a way to do this. Any insight would be greatly appreciated!