1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
#!/usr/bin/env python3
import csv
import random
def generate_large():
print("Generating large.csv (100,000 rows, 10 columns)...")
with open("large.csv", "w", newline="") as f:
writer = csv.writer(f)
for _ in range(100000):
writer.writerow(["cell" + str(random.randint(0, 1000)) for _ in range(10)])
def generate_wide():
print("Generating wide.csv (1,000 rows, 1,000 columns)...")
with open("wide.csv", "w", newline="") as f:
writer = csv.writer(f)
for _ in range(1000):
writer.writerow(["cell" + str(random.randint(0, 100)) for _ in range(1000)])
def generate_quoted():
print("Generating quoted.csv (100,000 rows, 10 columns with quotes and newlines)...")
with open("quoted.csv", "w", newline="") as f:
writer = csv.writer(f)
for _ in range(100000):
writer.writerow(["\"quoted, string\n" + str(random.randint(0, 1000)) + "\"" for _ in range(10)])
if __name__ == "__main__":
generate_large()
generate_wide()
generate_quoted()
print("Done!")
|