Dec-13-2018, 04:51 PM
(This post was last modified: Dec-13-2018, 06:26 PM by ichabod801.)
I am trying to insert the data values from column_names '<class list>' and stock_data '<class list>' into a dicitonary. When I run the program it loops on all of the data and it only stores that last values of the stock_data. How can I add the entire list values to the data_dict?
import pandas as pd
def main():
data = pd.read_json("/home/mahmoud/Desktop/FB.json", orient='records')
company_name = data['dataset']['name']
columns_names = data['dataset']['column_names']
stock_data = data['dataset']['data']
data_dict = {}
for rows in range(len(stock_data)):
for columns in range(12):
dataValues = {column_name[columns]:stock_data[rows][columns]}
for val in dataValues:
print(val, dataValues[val])
if __name__ == '__main__':main()
