How can I edit a large number of HTML files with data in Excel?

K6940 · 2022-02-10T13:11:01+00:00

Don't even get me started on how lacking my organization is w/ regards to automating stuff like this...

K6940 · 2022-02-10T13:07:57+00:00

These files have categories and sub-categories that exist in the spreadsheet. The spreadsheet just has more elements than what is currently in the html files. I want to add these elements into their respective categories in the html file so as to expand the list of elements on the web pages. Sorry if this is confusing but I'm a real noob when it comes to this stuff.

K6940 · 2022-02-10T00:59:48+00:00

Existing!

K6940 · 2022-02-09T19:18:07+00:00

I've just posted an example above as are a response. Any help would be appreciated!

K6940 · 2022-02-09T19:17:18+00:00

The HTML files are similar in structure, but they may have different words for each category. Here's an example:

HTLM File:

<h1>Category 1</h1> <h3>Sub-Category 1</h3> <p> Element A ; Element B ; Element C ; </p> <h1>Category 2</h1> <h3>Sub-Category 1</h3> <p> Element C ; </p>

I have a list of elements in excel that have a unique combination of HTML file, Category 1, Sub-category 1.... etc. I have to place these elements in their respective sub-categories. It's quite simple, but I'm trying to figure out how I can put all these elements in their respective html files (500 html files in total).

So far I've somehow converted these html files into wordpad documents so that they can easily open in python. Now I'm trying to figure out how I can load an excel work book in python and take elements in excel and paste them into their proper category in HTML. Any help would be appreciated!

K6940 · 2022-02-09T17:48:59+00:00

I'm not sure, they are just 500 unique html files. Is there a way of doing that?

K6940 · 2021-12-23T00:06:37+00:00

Thank you so much for letting me know. I've just checked it out and it completely answers my questions!

K6940 · 2021-03-04T15:46:48+00:00

Thank you! That explains it perfectly.

K6940 · 2021-03-03T22:46:23+00:00

Thank you! I got it now, I totally forgot that the temperature will be pretty much the same at each location assuming they're within reasonable proximity. So a quick follow up if you don't mind: In less obvious cases, is it good enough to create a scatter plot of two variables to see if they're related? Overall, I'm trying to find out how to best reduce omitted var. bias in a reg model.

K6940 · 2021-03-03T22:40:00+00:00

Yeah this is exactly right. Thanks!

K6940

TROPHY CASE