Parse text files with xml tags into a database, and output the database into an excel format.
$30-250 USD
Paid on delivery
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.
Project ID: #18795509
About the project
28 freelancers are bidding on average $161 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 have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. More
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
I can do this job, I have good experience in automation and parsing data to CSV n Excel files. .
Hey there! ** I don't think there is a use for a database, we can just push the data of each file into excel after processing and move to the next file. ** I will use pandas to create the excel or CSV files. p More
HI , we can help, but to provide you a quote can please provide us with the flat and xml files samples and the description of the data that needs to be extracted. We specialize on co-located teams in South America w More
Hello. How are you? I am highly interested to work on the "Parse text files with xml tags into a database, and output the database into an excel format.". I am a database programming expert. I have more than 7 year More
Hello there, I am an expert python developer with years of experience, I have worked on multiple python projects for both companies and individuals, I have exceptional analytical skills, and I am considered to be a gr More
Hi, I am a Full stack developer in Microsoft technologies. My area of expertise is web application development (asp.Net web forms, MVC, classic ASP), web services (SOAP & RESTFul), MySql & Sql Server as back end ( More
We specialize and have 20 years of experience in Desktop/Web/Mobile application development. We provide our expert service in the following areas: • Artificial Intelligence • Automation Solutions • Data Science • More
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. can I propose to do all your requirements in Excel, and Excel VBA itse More
I can write the perl script along with sql or mysql database and give you the expected result I am good in perl, php, sql, mysql along with devops and automation Please let me know if you are good to award this p More
Hey there! I found your project and I'm capable of making it. If you're interested just leave me a message. Thanks.