python如何定义一个数组接收数据_如何在Python中创建数据框数组

I want to write a piece of code to create multiple arrays of dataFrames with their names in the format of word_0000, where the four digits are month and year.

An example of what I'd like to do is to create the following dataframes:

df_0115, df_0215, df_0315, ... , df_1215

stat_0115, stat_0215, stat_0315, ... , stat_1215

解决方案

I suggest that you create a dictionary to hold the DataFrames. That way you will be able to index them with a month-day key:

import datetime as dt

import numpy as np

import pandas as pd

dates_list = [dt.datetime(2015,11,i+1) for i in range(3)]

month_day_list = [d.strftime("%m%d") for d in dates_list]

dataframe_collection = {}

for month_day in month_day_list:

new_data = np.random.rand(3,3)

dataframe_collection[month_day] = pd.DataFrame(new_data, columns=["one", "two", "three"])

for key in dataframe_collection.keys():

print("\n" +"="*40)

print(key)

print("-"*40)

print(dataframe_collection[key])

The code above prints out the following result:

========================================

1102

----------------------------------------

one two three

0 0.896120 0.742575 0.394026

1 0.414110 0.511570 0.268268

2 0.132031 0.142552 0.074510

========================================

1103

----------------------------------------

one two three

0 0.558303 0.259172 0.373240

1 0.726139 0.283530 0.378284

2 0.776430 0.243089 0.283144

========================================

1101

----------------------------------------

one two three

0 0.849145 0.198028 0.067342

1 0.620820 0.115759 0.809420

2 0.997878 0.884883 0.104158