def generateWordsFromIndices(wordSeriesIDs, earliestDate, latestDate):
wordSize = len(wordSeriesIDs)
# Get Data Series
words = None
dates = None
for i in range(wordSize):
data = EM_DBHelp.getWordHistory_WordHistoryTable(
db_connection, db_cursor, wordSeriesIDs[i], beforeDate=latestDate, afterDate=earliestDate
)
dt = np.dtype("int,float")
data = np.array(data, dtype=dt)
data.dtype.names = ["dates", "values"]
if words is None:
words = np.empty((len(data), wordSize))
dates = data["dates"]
if not (data["dates"] == dates).all():
raise Exception("Dates for different series do not match up")
words[:, i] = data["values"]
# Tuplefy words
numWords = words.shape[0]
for j in range(numWords):
words[j, :] = tuple(words[j, :])
# Return
return (dates, words)
