Shulou(Shulou.com)06/01 Report--

This article mainly introduces the relevant knowledge of "how Python converts csv files into xml files in batches". The editor shows you the process of operation through an actual case. The method of operation is simple, fast and practical. I hope that this article "how to convert csv files into xml files in batches by Python" can help you solve the problem.

I. Preface

Comma-separated values (Comma-Separated Values,CSV, sometimes referred to as character-separated values, because delimiters can also be non-commas) whose files store table data (numbers and text) in plain text. Plain text means that the file is a sequence of characters and does not contain data that must be interpreted like binary numbers. An CSV file consists of any number of records, separated by some kind of newline character; each record consists of fields, the delimiters between the fields are other characters or strings, the most common being commas or tabs. Typically, all records have exactly the same sequence of fields, usually plain text files.

Extensible markup language, a subset of the standard general markup language, referred to as XML. Is a markup language for tagging electronic documents to make them structural. In electronic computers, tags refer to information symbols that computers can understand. Through such marks, computers can process all kinds of information, such as articles, etc. It can be used to mark data and define data types. It is a source language that allows users to define their own markup language. It is ideal for World wide Web transmission and provides a unified way to describe and exchange structured data independent of applications or vendors.

Second, Python code implementation

Import used libraries

From xml.etree.ElementTree import Element, ElementTreeimport csvfrom pathlib import Pathimport os

Create a folder to save the converted xml file

# create a folder to save the converted xml file path = os.path.join ('xml_file') if not os.path.exists (path): os.mkdir (path)

Get all csv files to be converted

# get the return list of all csv files to be converted def list_csv (): file_path = input ('Please enter the path where you store the csv file:') p = Path (file_path) csv_files = p.glob ('* * / * .csv') csv_files = [str (csv_file) for csv_file in csv_files] return csv_files

Convert csv files to xml files

# convert csv file to xmldef csv_to_xml (file_name): print (file_name) with open (file_name, 'ringing, encoding='utf-8') as f: # read csv file reader = csv.reader (f) header = next (reader) # skip the header root = Element (' Datas') print ('root') Len (root)) # handles conversion for row in reader: erow = Element ('row') root.append (erow) for tag, text in zip (header, row): e = Element (tag) e.text = text erow.append (e) beatau (root) return ElementTree (root) def beatau (e Level=0): if len (e) > 0: e.text ='+'* (level + 1) child = None for child in e: beatau (child, level + 1) child.tail = child.tail [:-1] e.tail =''+'* level

Main function call

If _ _ name__ = ='_ main__': csv_list = list_csv () print (csv_list) for index_, item in enumerate (csv_list, start=1): print (index_, item) et = csv_to_xml (item) et.write (path +'/'+ 'test_ {} .xml' .format (index_)) Encoding='utf-8') this is the end of the introduction to "how Python converts csv files into xml files in batches" Thank you for your reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.