Terminé

Parse text files with xml tags into a database, and output the database into an excel format.

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.

Compétences : Développement de bases de données, Programmation de bases de données, Python, XML

en voir plus : java parse text files, parser parse text files, parse text files, excel xml format, excel xml mapping repeating elements, how to open xml file in excel 2010, export excel to xml, how do i convert an xml file to excel?, excel xml schema, import multiple xml files into excel, xml to excel mac, parse text files excel, using mysql java parse text files, java code parse text files, java parse text files numbers, oracle report output excel format, parse text files php, parse text files paragraph java, php output excel format, write java program parse text files

Concernant l'employeur :
( 0 commentaires ) Stamford, United States

Nº du projet : #18795509

Décerné à:

mankit121

Hey I am professional python programmer having all necessary skills to complete this project.I have gone through your project and with python libraries like [login to view URL], csv and other framework this project Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(9 Commentaires)
3.0

34 freelance font une offre moyenne de $160 pour ce travail

zhangyingtai

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(98 Commentaires)
7.4
gangabass

I can provide you a simple to use Python script that will process all text / XML files you have, parse each file and save information into SQL database after that you'll be able to export your database into CSV or Exce Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(209 Commentaires)
6.7
huangrong180405

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(9 Commentaires)
6.0
AtlanticSoft

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(10 Commentaires)
5.8
schoudhary1553

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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(25 Commentaires)
5.8
vano101

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(126 Commentaires)
5.6
anuyadav1

I can do this job, I have good experience in automation and parsing data to CSV n Excel files. .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(58 Commentaires)
5.9
kipdev13

Hi, Dear! I`m great interested in your suggest. If you're interested - contact me. Let's get in touch to discuss your project in more detail via here. It would be great to discuss details Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(39 Commentaires)
5.5
Mickelson

Hi Nice to meet you. I have enough experience in python script. Below the libraries are I used in past project. selenium, pandas, matplotlib, lxml, beautifulsoup, scipy, and other useful libraries. I have written Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(34 Commentaires)
5.6
ChanakyaNaag

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(32 Commentaires)
4.9
ecombucketsoft

Hi there, Hope you doing great. I can write script for you to pull data form a xml and store in db/csv . I am a Full Stack Developer (Django + Angular ) developer with 4.5+ years of experience. You can view my work Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(23 Commentaires)
5.0
novepi1

Hi there, The requirements are quite clear and straightforward to implement. Since all of your files have the same layout the first step will be to create a db schema from that. Once the schema is ready then I'll cr Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(16 Commentaires)
5.1
yesikov1224

I have developed real projects such as data converting and data scraping by C#, Python. I have done data entries such as Access and Excel VBA. I have done the Mobile App projects, Web projects or Desktop App project Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(15 Commentaires)
5.1
lightingdavid

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(12 Commentaires)
4.5
periyannas

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)
4.1
ahmedkhaled2105

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(12 Commentaires)
3.6
deepthi2889

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 ( Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(5 Commentaires)
3.8
JoBergs

Hello! Python is very well suited for the task you described. I'd propose using the Python module LXML for the XML parsing and i'd prefer storing the data in a MySQL database, since i'm most experienced with that. I Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(5 Commentaires)
2.9
eternalmisery

Hey there! I found your project and I'm capable of making it. If you're interested just leave me a message. Thanks.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(3 Commentaires)
2.6
ypdevelop

Dear sir, I have read your project carefully and have interested in this job. I am a python developer with 7+ years of experience. I have a deep comprehension in parsing and database. This project is suitable for m Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(2 Commentaires)
2.7