MetaR | Simple Data Analysis language built with MPS | BPM library

I am working on a project that calls an API (using C# ASP.NET), and the API returns an XML document. I know how to deserialize an response in JSON, but am running into issues with deserializing an XML response. Currently I am getting the below error when attempting to deserialize the XML:

InvalidOperationException: response xmlns="" was not expected.

The error code displayed just the empty quotes in the error message. I have the code samples below, and I would greatly appreciate any constructive feedback or advice on making this better, and any advice on where I went wrong on attempting to deserialize this!

Here is the XML response from the API call (This API only returns either CML or a .csv):

I have been using the "Gridding METAR Observations" example code from MetPy Mondays #154 for some time without any issues. Up until recently, I passed the entire data set without restrictions (except to exclude stations near the South Pole, which were blowing up the Lambert Conformal transformation.)

Recently, I tried to restrict the domain of the METAR data I process to North America. At this point, MetPy's interpolate_to_grid function seems to be returning nan when it did not previously. Since my region of interest is far removed from the boundaries of the data set, I expected no effect on contours derived from the interpolated data; instead there is a profound effect (please see the example below.) I tried to interpolate over regions of missing data (nan) using SciPy's interp2d function, but there are too many nan to overcome with that "bandaid step".

Question: Is this expected behavior with interpolate_to_grid, or am I using it incorrectly? I can alway continue to use the entire data set, but that does slow things down a bit. Thanks for any help understanding this.

In the following example, I am using the 00Z.TXT file from https://tgftp.nws.noaa.gov/data/observations/metar/cycles/, but I am seeing this with METAR data from other sources.

I am trying to stringify an array and get the specific value where another value equals EFHK_ATIS:

I'm trying to make a GET request to a REST Aviation Weather API called AVWX but after performing the request it holds for about 10 seconds and then I get the following error displayed in the console:

I am trying to extract all the strings end with "KT" and put them into one cell, however it only show the first result (24010KT) Preferred result: 24010KT,VRB05KT,21008KT,26008KT,VRB04KT

I used below formula, =REGEXEXTRACT(A1,"\w+KT")

String in A1 // TAF 110500Z 1106/1212 24010KT 9999 FEW010 SCT030 TX33/1106Z TX32/1206Z TN28/1122Z TEMPO 1106/1112 4000 SHRA FEW010CB SCT020 TEMPO GR 1109/1115 VRB05KT TEMPO 1120/1202 4000 SHRA FEW010CB SCT020= SS METAR 110630Z 21008KT 190V250 9999 FEW018 32/24 Q1007 NOSIG=
METAR 110530Z 26008KT 240V300 9999 2800N SHRA FEW018 31/26 Q1008 NOSIG= SS METAR 110430Z VRB04KT 9999 FEW018 SCT028 32/25 Q1008 NOSIG= //

I would like to import a specific part of this XML directly into my dataGridView in Windows Forms, without downloading the XML file.

Current working code, which is downloading the complete file (not wanted):

I am currently working on an aviation weather Discord bot where the user can request the specific weather of an airport. So for example, when you will type in: !metar KJFK it should return the METAR (Meteorological Aerodrome Report) and TAF (Terminal Aerodrome Forecast). At this moment, I got it working but it returns one-liners. This is the result I get when I enter the ICAO station of Amsterdam-Schiphol:

Input: !METAR EHAM Output:

I am currently stuck with a Python project where I want to get the information out of an online CSV file and want to let the user search via an input function. At the moment, I am able to get the information from the online CSV file via a link but I cannot make the connection so that it searches the exact word in that CSV file.

I currently have tried multiple tutorials but most of them aren't solving my issue. So with a lot of pain, I am writing this message here, hoping someone can help me out.

The code I have so far is:

I have the following piece of code based on PythonMETAR (some sort of weather codification in aviation) library: