json

save

• example #1

import pandas as pd

data = {
    '이름': ['홍길동', '김철수', '이영희'],
    '나이': [25, 30, 22],
    '도시': ['서울', '부산', '대전']
}

df = pd.DataFrame(data)

# JSON 파일로 저장
df.to_json('example.json', orient='records', force_ascii=False, indent=2)

• example #2

sample = [[1,2,3,4,5,6],
          [7,8,9,10,11,12],
          [13,14,15,16,17,18]]
          
with open('sample.json', 'r', encoding='utf-8') as f:
    loaded = json.load(f)

print(loaded)

load

• example #1

df = pd.read_json('example.json')
print(df)

• example #2

import json

with open('sample.json', 'w', encoding='utf-8') as f:
    json.dump(sample, f, indent=2)

csv/tsv

load

• example #1

import pandas as pd

# CSV 파일 불러오기
df = pd.read_csv('example.csv', encoding='utf-8-sig')  # 저장할 때 쓴 인코딩과 동일하게 맞춰야 함

# 데이터 출력
print(df)

• example #2

with open('sample.csv', 'r') as f:
    reader = csv.reader(f)
    loaded = [list(map(int, row)) for row in reader]

print(loaded)

save

• example #1

import pandas as pd

# 예시 데이터프레임 생성
data = {
    '이름': ['홍길동', '김철수', '이영희'],
    '나이': [25, 30, 22],
    '도시': ['서울', '부산', '대전']
}

df = pd.DataFrame(data)

# CSV 파일로 저장
df.to_csv('example.csv', index=False, encoding='utf-8-sig')  # Excel에서 한글이 깨지지 않게 하려면 utf-8-sig 권장

• example #2

import csv

sample = [[1,2,3,4,5,6],
          [7,8,9,10,11,12],
          [13,14,15,16,17,18]]

with open('sample.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerows(sample)
          

txt

load

• example #1

with open('example.txt', 'r', encoding='utf-8') as f:
    lines = f.readlines()
    for line in lines:
        print(line.strip())

• example #2

with open('sample.txt', 'r', encoding='utf-8') as f:
    loaded = [list(map(int, line.strip().split())) for line in f]

print(loaded)

save

• example #1

with open('example.txt', 'w', encoding='utf-8') as f:
    for i in range(len(df)):
        f.write(f"{df.iloc[i]['이름']}, {df.iloc[i]['나이']}, {df.iloc[i]['도시']}\n")

• example #2

sample = [[1,2,3,4,5,6],
          [7,8,9,10,11,12],
          [13,14,15,16,17,18]]
          
with open('sample.txt', 'w', encoding='utf-8') as f:
    for row in sample:
        f.write(' '.join(map(str, row)) + '\n')