Path: ...!weretis.net!feeder8.news.weretis.net!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Mark Jackson <mjackson@alumni.caltech.edu>
Newsgroups: rec.autos.sport.f1
Subject: Re: **2024 Pool** Race 22, United States GP
Date: Tue, 5 Nov 2024 10:23:51 -0500
Organization: =?UTF-8?Q?Bureau_Central_de_Recherches_Surr=C3=A9alistes?=
Lines: 36
Message-ID: <lourk7F4cgeU2@mid.individual.net>
References: <vga45h$sja3$3@dont-email.me> <lorsuvF4cgdU2@mid.individual.net>
 <vgahms$v4dr$1@dont-email.me> <Rs8pZ+8EItJRCO9csz1dH1=MPmcR@4ax.com>
 <vgcnoq$1euoe$1@dont-email.me>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: individual.net hnR3QL/tfRA3VKg9AV2+/Q1cTA+34NWu/E7QDNNBd1yvl0k9Lx
Cancel-Lock: sha1:UTM3oYpXSKKUX6uKatAPo6rXzCA= sha256:RvDYCCvEynMrHhQmIPflynWexRdjLgQEnxBqTqJvAfY=
User-Agent: Mozilla Thunderbird
Content-Language: en-US
In-Reply-To: <vgcnoq$1euoe$1@dont-email.me>
Bytes: 2474

On 11/5/2024 4:16 AM, Mark wrote:

>> On Mon, 4 Nov 2024 13:20:28 -0000 (UTC), Mark <mpconmy@gmail.com>
>> wrote:
>>>
>>> I used to update it a few times during the season - fully automated and
>>> taken straight from the F1 web page - but they've made the data _so_
>>> horrible (and change it even mid-season) it's become semi-manual and
>>> long-winded.

The "Classification" page at

http://www.forix.com/gp.php?l=0&r=20240021&c=2

is a lot cleaner, if you have access.  (The table of results is easy to 
find and copy out.)

> It is one of the reasons I'm a bit slower with results the last couple
> of years. For a decade, that was fully automated. A Python script would
> parse the F1 website, compile the full set of results and inject them
> into the SQL table. Another script would then build the results post.

I still have occasion to write scripts to do things like take text 
output from an Excel file and turn it into an HTML table - the former 
being a lot easier than the latter for adding and removing entries 
without screwing up the layout.

They're in Python, of course.  It wasn't the NBA star of the same name 
who coined the marketing slogan that used to be used on Python.org:

https://groups.google.com/g/comp.lang.python/c/yVEsK9m74SE/m/3L0yPGHjxgsJ

-- 
Mark Jackson - https://mark-jackson.online/
   If you can't write comedy about Caltech,
   you can't write comedy.  - J. Kent Clark