Python 虚拟数据：将随机文本和数字数据生成一个CSVEXCEL文件

我猜你想要从单词中生成一个包含5万个随机 Select 的列表--这些单词本身可以重新命名为Boroughes:

import random
import pandas as pd
import numpy as np

SIZE = 50_000
BOROUGHS = ["Chelsea", "Kensington", "Westminster", "Pimlico", "Bank", "Holborn", "Camden", "Islington", "Angel", "Battersea", "Knightsbridge", "Bermondsey", "Newham"]

np.random.seed(1)
data3 = pd.DataFrame({"Sq. feet" : np.random.randint(low=75, high=325, size=SIZE),
  "Price" : np.random.randint(low=200000, high=1250000, size=SIZE),
  "Borough" : [random.choice(BOROUGHS) for _ in range(SIZE)]
})

df = pd.DataFrame(data3)
df.to_csv("realestate.csv", index=False)
print(df)

Output

       Sq. feet    Price      Borough
0           112   345382      Pimlico
1           310   901500    Battersea
2           215   661033      Holborn
3           147  1038431  Westminster
4           212   296497      Holborn
...         ...      ...          ...
49995       252  1065034      Holborn
49996       117   752615      Holborn
49997       238   803058       Camden
49998       147  1163555         Bank
49999       269   888623  Westminster

撇开...无论您的代码中有一个重复的数字，比如50,000，通常将其作为变量并在顶部声明它是一个好主意，然后可以更改它，而不会给一些贫穷的future 程序员带来维护噩梦，因为他们会到处寻找50,000的每一个出现的地方.

如果你想了解它们，这个 struct 被称为"list comprehension":

[random.choice(BOROUGHS) for _ in range(SIZE)]