Das deutsche Python-Forum

Code: Alles auswählen

__author__ = 'Mike'

import csv

def add_column():

    print("Add a new column, follow the introduction....")

    name_column = str(input("Enter the name of the new column: "))
    type_column = str(input("Enter the type ot the new column (e.g. RP,NP,SAX,WAX,CIRAL: "))
    lenght_column = input("Enter the lenght of the new column [mm]: ")
    dia_column = input("Enter the diameter of the new column: ")
    porsize_column = input("Enter the poresize of the new column: ")
    particlesize_column = input("Enter the particlesize of the new column [µm]: ")


    dataset_column= '%s,%s,%s,%s,%s,%s' %(name_column,type_column,lenght_column,dia_column,porsize_column,particlesize_column)


    fobj = open("column.csv", "w")
    for engl in dataset_column:
        fobj.write( dataset_column + "\n")
    fobj.close()


add_column()

Code: Alles auswählen

 
 fobj = open("Column.csv", "w")
 fobj.write( dataset_column + "\n")
 fobj.close()

Code: Alles auswählen

import csv

CSV_FILE_NAME = 'rows.csv'
FIELD_NAMES = [
    'name',
    'type',
    'lenght',
    'dia',
    'porsize',
    'particlesize',
]

def init():
    with open(CSV_FILE_NAME, 'w') as csv_file:
        writer = csv.DictWriter(csv_file, fieldnames=FIELD_NAMES)
        writer.writeheader()

def add_row(filename):
    print('Add a new row, follow the introduction....')
    record = dict(
        name=input('Enter the name of the new row: '),
        type=input('Enter the type ot the new row (e.g. RP,NP,SAX,WAX,CIRAL: '),
        lenght=input('Enter the lenght of the new row [mm]: '),
        dia=input('Enter the diameter of the new row: '),
        porsize=input('Enter the poresize of the new row: '),
        particlesize=input('Enter the particlesize of the new row [µm]: '),
    )
    with open(CSV_FILE_NAME, 'wa') as csv_file:
        writer = csv.DictWriter(csv_file, fieldnames=FIELD_NAMES)
        writer.write(record)

init()
for _ in range(int(input('Enter the number of rows you want to add: '))):
    add_row()