I have a task that requires processing lots of data in python. I need to parse the data from text files in XML and write the data into a database such as SQL. Next, I would then like to be able to output the contents of the database into an excel or .csv format.
Specifically, I have dozens of text files that are coded using the same format in XML. I would like to create a program in python that can:
1. Rename each text file.
2. Loop through each text file, and identify elements of text file by their XML tags. There are many tags (possibly a hundred). Each text file follows the same format but the tags can be either in text or numbers.
3. While looping through each text file, writing the data into an SQL database (or a similar kind of database). This would require writing the name of the text file and all the tags associated with it into the database to be able to be stored.
4. Outputting all the information in the database into an excel or .csv format. This is so I can review the data and be able to neatly format it.
Requirements would be a strong knowledge of Python (I am currently using Python version 3.6), text file parsing and XML (possibly ElementTree), a database language (such as SQLite 3 or any preferred method) and translating the database to excel or .csv format.
34 freelancers are bidding on average $160 for this job
Hello sir I have 9 years of experience about python. I checked the requirements and I am clear. I am ready to start the work and can complete the task in 2 days. Best Regards, Yongtao
Hello. I am very interested to your project. I have a wealthy experience of python and data mining. I can satisfy all your requirements. Please contact me and let discuss in detail. Thanks.
Hello I have over 2 years of experience with Python, including working with XML through ElementTree and SQLIte. Could you send some of samples of you XML files to handle? Thanks