-
Notifications
You must be signed in to change notification settings - Fork 192
/
random.py
184 lines (148 loc) · 6.47 KB
/
random.py
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
from __future__ import absolute_import, print_function, division
import datetime
import random
import time
from collections import OrderedDict
from functools import partial
from petl.compat import xrange, text_type
from petl.util.base import Table
def randomtable(numflds=5, numrows=100, wait=0, seed=None):
"""
Construct a table with random numerical data. Use `numflds` and `numrows` to
specify the number of fields and rows respectively. Set `wait` to a float
greater than zero to simulate a delay on each row generation (number of
seconds per row). E.g.::
>>> import petl as etl
>>> table = etl.randomtable(3, 100, seed=42)
>>> table
+----------------------+----------------------+---------------------+
| f0 | f1 | f2 |
+======================+======================+=====================+
| 0.6394267984578837 | 0.025010755222666936 | 0.27502931836911926 |
+----------------------+----------------------+---------------------+
| 0.22321073814882275 | 0.7364712141640124 | 0.6766994874229113 |
+----------------------+----------------------+---------------------+
| 0.8921795677048454 | 0.08693883262941615 | 0.4219218196852704 |
+----------------------+----------------------+---------------------+
| 0.029797219438070344 | 0.21863797480360336 | 0.5053552881033624 |
+----------------------+----------------------+---------------------+
| 0.026535969683863625 | 0.1988376506866485 | 0.6498844377795232 |
+----------------------+----------------------+---------------------+
...
Note that the data are generated on the fly and are not stored in memory,
so this function can be used to simulate very large tables.
"""
return RandomTable(numflds, numrows, wait=wait, seed=seed)
class RandomTable(Table):
def __init__(self, numflds=5, numrows=100, wait=0, seed=None):
self.numflds = numflds
self.numrows = numrows
self.wait = wait
if seed is None:
self.seed = datetime.datetime.now()
else:
self.seed = seed
def __iter__(self):
nf = self.numflds
nr = self.numrows
seed = self.seed
# N.B., we want this to be stable, i.e., same data each time
random.seed(seed)
# construct fields
flds = ['f%s' % n for n in range(nf)]
yield tuple(flds)
# construct data rows
for _ in xrange(nr):
# artificial delay
if self.wait:
time.sleep(self.wait)
yield tuple(random.random() for n in range(nf))
def reseed(self):
self.seed = datetime.datetime.now()
def dummytable(numrows=100,
fields=(('foo', partial(random.randint, 0, 100)),
('bar', partial(random.choice, ('apples', 'pears',
'bananas', 'oranges'))),
('baz', random.random)),
wait=0, seed=None):
"""
Construct a table with dummy data. Use `numrows` to specify the number of
rows. Set `wait` to a float greater than zero to simulate a delay on each
row generation (number of seconds per row). E.g.::
>>> import petl as etl
>>> table1 = etl.dummytable(100, seed=42)
>>> table1
+-----+----------+----------------------+
| foo | bar | baz |
+=====+==========+======================+
| 81 | 'apples' | 0.025010755222666936 |
+-----+----------+----------------------+
| 35 | 'pears' | 0.22321073814882275 |
+-----+----------+----------------------+
| 94 | 'apples' | 0.6766994874229113 |
+-----+----------+----------------------+
| 69 | 'apples' | 0.5904925124490397 |
+-----+----------+----------------------+
| 4 | 'apples' | 0.09369523986159245 |
+-----+----------+----------------------+
...
>>> # customise fields
... import random
>>> from functools import partial
>>> fields = [('foo', random.random),
... ('bar', partial(random.randint, 0, 500)),
... ('baz', partial(random.choice,
... ['chocolate', 'strawberry', 'vanilla']))]
>>> table2 = etl.dummytable(100, fields=fields, seed=42)
>>> table2
+---------------------+-----+-------------+
| foo | bar | baz |
+=====================+=====+=============+
| 0.6394267984578837 | 12 | 'vanilla' |
+---------------------+-----+-------------+
| 0.27502931836911926 | 114 | 'chocolate' |
+---------------------+-----+-------------+
| 0.7364712141640124 | 346 | 'vanilla' |
+---------------------+-----+-------------+
| 0.8921795677048454 | 44 | 'vanilla' |
+---------------------+-----+-------------+
| 0.4219218196852704 | 15 | 'chocolate' |
+---------------------+-----+-------------+
...
Data generation functions can be specified via the `fields` keyword
argument.
Note that the data are generated on the fly and are not stored in memory,
so this function can be used to simulate very large tables.
"""
return DummyTable(numrows=numrows, fields=fields, wait=wait, seed=seed)
class DummyTable(Table):
def __init__(self, numrows=100, fields=None, wait=0, seed=None):
self.numrows = numrows
self.wait = wait
if fields is None:
self.fields = OrderedDict()
else:
self.fields = OrderedDict(fields)
if seed is None:
self.seed = datetime.datetime.now()
else:
self.seed = seed
def __setitem__(self, item, value):
self.fields[text_type(item)] = value
def __iter__(self):
nr = self.numrows
seed = self.seed
fields = self.fields.copy()
# N.B., we want this to be stable, i.e., same data each time
random.seed(seed)
# construct header row
hdr = tuple(text_type(f) for f in fields.keys())
yield hdr
# construct data rows
for _ in xrange(nr):
# artificial delay
if self.wait:
time.sleep(self.wait)
yield tuple(fields[f]() for f in fields)
def reseed(self):
self.seed = datetime.datetime.now()