legislative | Participation channel to bring information

I'm using the Geocodio API to find congreessional district information for a given address. Here's my code:

I'm looking to do something with bills that have been delivered to the governor - collecting dates for when they were delivered and the date of the last legislative action before they were sent.

I'm doing this for a whole series of similar URLs. Problem is, my code (below) works for some URLs and not others. I'm writing this to a pandas dataframe and then to csv file. When the code fails, it writes the else block when either if of elif should've been triggered.

Here's a fail URL: https://www.nysenate.gov/legislation/bills/2011/s663 And a succeed URL: https://www.nysenate.gov/legislation/bills/2011/s333

Take the first URL for example. Underneath the "view actions" dropdown, it says it was delivered to the governor on Jul 29, 2011. Prior to that, it was returned to assembly on Jun 20, 2011.

Using "delivered to governor" location as td in the table, I'd like to collect both dates using Bs4.

Here's what I have in my code:

I have created an XML diff but the diff is unclean in that it sometimes marks both the parent but also some of the children as changed.

I would like to clean up the diff so that only the topmost marked element keeps the diff attribute.

In the example below, I only want to keep the diff:delete attribute on the element, but remove it from all children of , since is already marked.

The input is Docbook and arbitrary elements can contain diff attributes.

Here is my XML:

I have been practicing on iterating through dictionary and list in Python.

The source file is a csv document containing Country and Capital. It seems I had to go through 2 for loops for country_dict in order to produce the same print result for country_list and capital_list.

Is there a better way to do this in Python dictionary?

The code:

I have imported into my mongoDB collection a set of geoJSON polygons that equate to the legislative districts in the Commonwealth of Pennsylvania. This data came from a geoJSON file on Penn State University's website and different tools do draw from the file correctly, which tells me the original data is valid.

I imported it by loading the data into an array and iterating through each entry and populating the corresponding geometry fields in the mongoosejs schema. The schema for a district looks like this:

Goal

I'm trying to create a map in ggplot of the French 2017 election results that fills each electorate with the colour of the winning party.

Problem

When I map the shapefile of French electorates with geom_sf, the fill argument doesn't recognise the hexadecimal values I feed it for each party's colour. Instead it assigns each party a new colour.

My map should be coloured like this correct party colours

But ggplot currently colours it like this incorrect party colours

Code

I have a shapefile of all french electorates, here, which in R looks like

I asked this question in the wrong way, so I am back to see if I can get it straight. Queried a local mariaDB instance for for variables on tens of thousands of lines of data. One of the objects was stored as a LONGBLOB and so the returned tibble has three character vectors and one is a list of raw binaries. Code is as follows.

The LONGBLOB data is XML data with forms that contain legislative language and data on the legislature.

I'm trying to webscrape tables from the humane society legislative fund. The following code successfully gets the data from one of the pages:

I have successfully scraped a table that I want to display in a .xlsx

When it's displayed in a browser, that is how I want it displayed in excel.

The way it should be displayed would be

A1 = 1.

B1 = Prepare to assist with actions and activities associated with incident response

C1 = 1.1

D1 = Identify duty holders and WHS legislative requirements for incident response

A2 = Blank

B2 = Blank

C2 = 1.2

D2 = Identify workplace policies, procedures and processes concerning incident response planning and reporting

The code that I have is below, followed by the HTML that I've scraped.