Write a program that can read and write from/to a csv file and modify files in a filesystem.
We have a folder containing ten websites. We are looking for a one-click solution that will allow us to batch delete [login to view URL] files in each folder and replace them with a standard [login to view URL] page that's populated with correct info from a csv file.
(CSV rows do not have to be mapped, program will run through whatever data is in the spreadsheet on a given folder of websites and change them according to what is present in the csv)
For every folder:
Program will use a CSV file as data.
Program will use [login to view URL] as an html template.
Program will search recursively in each folder for [login to view URL] or [login to view URL] files.
Program will delete existing [login to view URL] files found in folder.
Program will edit the [login to view URL] template with data found in spreadsheet.
For each folder the program will searches recursively for [login to view URL] or contact.html.
If found, it will delete the [login to view URL]
Then it creates a new [login to view URL] or [login to view URL] in its place (to preserve existing nav links).
So, for example:
A folder named website-1 has a [login to view URL] page in its root directory.
The script will delete the [login to view URL] page and replace it with the template contact.html.
Folder website-2 has a [login to view URL] located under /contact/[login to view URL] from its root. Program will delete the file under /contact/[login to view URL] and replace it with the [login to view URL] template under the same path. HOWEVER it must write the name of the file as [login to view URL], the same as before, in order to preserve existing nav links.
The new [login to view URL] is going to have a generic template. The info in the contact page will be different according to the addresses listed in the spreadsheet. Each row of the spreadsheet corresponds to a company.
Program iterates through whatever data is in the csv regardless of folders, it will make changes to the first folder, in alphabetical order. We do not want to map the spreadsheet rows to individual folders manually.
please respond with PANDAS in your message body if you've read this far.
43 freelanceria on tarjonnut keskimäärin $481 tähän työhön
Somebody called for quality and saving time? We have just 3 steps! 1st- Let's talk in the chat *** I WILL CATCH YOU LESS THAN A MINUTE*** 2nd- Finalize exactly what we want 3rd- Start a journey to the creativity
Hello, I'm a professional Python developer, specialized in data science. PANDAS is one of the skills I use most in my daily job. Please, contact me for an efficient,documented and fast soltuion.