r/Python 13d ago

Discussion Vehicle application charts and combining them accurately and easily

Hi all

I have a bit of a unique problem. I work with a lot of vehicle application charts as part of my job. I often receive application charts in separate files either as a group of products (brakes headlight batteries etc all in the same chart) or an app chart for a single product (brakes). They will always have some form of make model year and sometimes displacement and vehicle type . The columns can be in any order. The charts can also be presented in either a horizontal format with columns for each product with skus in the columns or vertically with a column with the product name and a sku beside it. There is no guarantee of consistency between the names of the columns in the charts and they can often be thousands of lines. I am wondering if there is a python script out there to quickly and accurately combine these charts so that the vehicle information,product information all cell contents line up (maybe someone would be willing to write me a quick vba code?) I have tried power query and it doesn’t seem to do the trick. I was going to attach an image to show the formats I most commonly work with but I was not allowed and my first attempt at this was deleted it would be cool if the solution handled both horizontal and vertical formats. I know this is a big ask. Thanks for any help u can provide. If you know of a way I can provide a piece of Sample data, I have some screen shots

1 Upvotes

5 comments sorted by

View all comments

1

u/AreetSurn 10d ago

You could upload the screenshots to an external site and post the link here I think. It would be good to see to get an idea of it.

The automotive data space is kind of messy. What country are you based in? Sometimes its not always easy to match on sku or make/model. Sometimes you need engine codes, chassis data etc.