TIL 16. CSV Import

1. CSV DB Import

csv.reader( ) 또는 csv.DictRedader( )라는 메소드를 이용하면 매우 쉽게 .csv 파일을 다룰 수 있습니다

import csv #csv파일을 다루기 위한 라이브러리를 import 합니다.

with open('wecode.csv') as csv_file:
    rows = csv.reader(csv_file, delimiter = ',')
		for row in rows:
				print(row)

2. 사용 예시

import csv
import os
import django
from decimal import Decimal

os.environ.setdefault("DJANGO_SETTINGS_MODULE", "mealkatmarket.settings")
django.setup()

from products.models import Food


def foodupload():
    CSV_PATH_PRODUCTS = './foods.csv'
    with open(CSV_PATH_PRODUCTS) as in_file:
        data_reader = csv.reader(in_file)
        next(data_reader,None)

        for row in data_reader:
            name1 = row[1]
            price1 = Decimal(row[2].replace(',',''))

            if row[3] == '':
                row[3] = 0

            discount1 = row[3]
            discounted_price1 = Decimal(row[4].replace(',',''))
            star_score1 = Decimal(row[5].replace(',',''))
            review_count1 = row[6].replace(',','')
            detail_image1 = row[7]

            Food.objects.create(
                name = name1,
                price = price1,
                discount = discount1,
                discounted_price = discounted_price1,
                star_score = star_score1,
                review_count = review_count1,
                detail_image = detail_image1
            )