Data-2-Csv-Xlsx

Sat 17 May 2025

import pyutil as pyu
pyu.get_local_pyinfo()
'conda env: ml312-2024; pyv: 3.12.7 | packaged by Anaconda, Inc. | (main, Oct  4 2024, 13:27:36) [GCC 11.2.0]'
print(pyu.ps2("pandas faker"))
pandas==2.2.3
faker==33.1.0

from faker import Faker
import pandas as pd
fake = Faker()
rows_count = 10
data = {
    "Name": [fake.name() for _ in range(rows_count)],
    "Email": [fake.email() for _ in range(rows_count)],
    "City": [fake.city() for _ in range(rows_count)],
    "Country": [fake.country() for _ in range(rows_count)]
}
# data
df = pd.DataFrame(data)
df.index = df.index + 1
df.index.name = 'Index'
df.to_csv('fake_data_1.csv', index=True)


Score: 10

Category: pandas