Python Forum
writing data from Amazon Workspaces to CSV
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
writing data from Amazon Workspaces to CSV
#1
Hello,

I'm trying to get my output from Amazon Workspaces to print to a file. I can get the data from workspaces, but I have not been able to write the data to the CSV file. I have been looking around the web, and all the answers I can find are the simplest possible answers, and only print the code from within Python itself. I can find no real-world examples that adequately address my problem. Any assistance is appreciated, Thank you.

This is my code:
import boto3
client = boto3.client('workspaces')
folder = input('directoryId> ')

workspaces = client.describe_workspaces()['Workspaces']
directoryIds = [workspaces['DirectoryId']for workspaces in workspaces]
directoryIds.sort()


for DirectoryIds in folder:
print(workspaces)



##----------------CSV Writer Code----------------##


import csv
with open('workspacesdata.csv', 'w', newline='') as csvfile:
datawriter = csv.writer(csvfile,dialect='excel')

fieldnames=['WorkspaceId', 'DirectoryId', 'UserName', 'IpAddress','State', 'BundleId', 'SubnetId','ComputerName','VolumeEncryptionKey' , 'WorkspaceProperties','RunningMode']
datawriter = csv.DictWriter(csvfile, fieldnames=fieldnames)
datawriter.writeheader()



##----------------CSV Reader Code----------------##

import os
os.system('start excel.exe workspacesdata.csv')
Yoriz write Sep-22-2022, 10:47 PM:
Please post all code, output and errors (in their entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.
Reply
#2
(Sep-22-2022, 10:46 PM)isaac_python Wrote: I can get the data from workspaces, but I have not been able to write the data to the CSV file.
Can you show a sample on what raw data of workspaces look like.

Also to mention you are making basic mistakes that will not work.
This will just loop over the input string,as many character the input has in this case 4.
folder = 'id99' # input('directoryId> ')
for DirectoryIds in folder:
    print('workspaces')
Output:
workspaces workspaces workspaces workspaces
This part dos nothing as just print an create a empty workspacesdata.csv file.
most write to file fp.write(f'created {file_name}')
from datetime import datetime

x = datetime.now()
# create a file with date as a name day-month-year
file_name = x.strftime('%d-%m-%Y.txt')
with open('workspacesdata.csv', 'w') as fp:
    print('created', file_name)
Output:
created 23-09-2022.txt
But if the file was not empty it will just be overwritten by line 31.
w mode always overwrites the file if the file exists.
with open('workspacesdata.csv', 'w', newline='') as csvfile:
Reply
#3
(Sep-22-2022, 10:46 PM)isaac_python Wrote: Hello,

I'm trying to get my output from Amazon Workspaces to print to a file. I can get the data from workspaces, but I have not been able to write the data to the CSV file. I have been looking around the web, and all the answers I can find are the simplest possible answers, and only print the code from within Python itself. I can find no real-world examples that adequately address my problem. Any assistance is appreciated, Thank you.

This is my code:
[python]import boto3
client = boto3.client('workspaces')
folder = input('directoryId> ')

workspaces = client.describe_workspaces()['Workspaces']
directoryIds = [workspaces['DirectoryId']for workspaces in workspaces]
directoryIds.sort()


for DirectoryIds in folder:
    print(workspaces)

    
   
##----------------CSV Writer Code----------------##


import csv
with open('workspacesdata.csv', 'w', newline='') as csvfile:
    datawriter = csv.writer(csvfile,dialect='excel')
    
    fieldnames=['WorkspaceId', 'DirectoryId', 'UserName', 'IpAddress','State', 'BundleId', 'SubnetId','ComputerName','VolumeEncryptionKey' , 'WorkspaceProperties','RunningMode']
    datawriter = csv.DictWriter(csvfile, fieldnames=fieldnames)
    datawriter.writeheader()
  


##----------------CSV Reader Code----------------##

import os
os.system('start excel.exe workspacesdata.csv')
I should have probably mentioned I am new to using python, so I expect to make mistakes and I realized I have code that may not work.

As requested here is a snippet of the raw output that I want in my file:

Output:
'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-2ptlkm5qv', 'DirectoryId': 'd-92671ce35c', 'UserName': 'mdomi077', 'IpAddress': '10.113.91.208', 'State': 'AVAILABLE', 'BundleId': 'wsb-9mw5qstcj', 'SubnetId': 'subnet-055c1fd5f0f78926a', 'ComputerName': 'EC2AMAZ-T18AKN8', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/c0bf7254-4ed0-49db-b068-aa35aead1569', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-6bw7svsnp', 'DirectoryId': 'd-92672c445d', 'UserName': 'arico027', 'IpAddress': '10.159.250.248', 'State': 'AVAILABLE', 'BundleId': 'wsb-b31hkn0hd', 'SubnetId': 'subnet-0bd2f24ad8422306f', 'ComputerName': 'WSAMZN-T8VRNFTT', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/95d05f8e-7e21-4852-8cb8-f4a8505d8110', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-08h9cjkvt', 'DirectoryId': 'd-92670ed06d', 'UserName': 'vsanc079', 'IpAddress': '10.113.81.161', 'State': 'AVAILABLE', 'BundleId': 'wsb-35gdsrk4x', 'SubnetId': 'subnet-04f8860f4dbcbb4e4', 'ComputerName': 'WSAMZN-J6IHDJ93', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/bef5e0aa-2c8f-4b2d-8c31-9456e5de18ce', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-h6vs896fs', 'DirectoryId': 'd-92672c44a1', 'UserName': 'achoa004', 'IpAddress': '10.159.250.36', 'State': 'AVAILABLE', 'BundleId': 'wsb-gm4d5tx2v', 'SubnetId': 'subnet-0eb119c83fcd876b5', 'ComputerName': 'WSAMZN-JOSCE5IC', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/95d05f8e-7e21-4852-8cb8-f4a8505d8110', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 100, 'ComputeTypeName': 'PERFORMANCE'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-b1t8zwt6b', 'DirectoryId': 'd-926728fc2c', 'UserName': 'drahu001', 'IpAddress': '10.159.24.21', 'State': 'AVAILABLE', 'BundleId': 'wsb-8vbljg4r6', 'SubnetId': 'subnet-0c63e957', 'ComputerName': 'IP-C0A8D2AA', 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 50, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}]
I have simplified the code and made the suggested adjustments

import boto3
client = boto3.client('workspaces')
folder = input('directoryId> ')

workspaces = client.describe_workspaces()['Workspaces']
directoryIds = [workspaces['DirectoryId']for workspaces in workspaces]
directoryIds.sort()

for DirectoryIds in folder:
    print(workspaces)

    
   
##----------------CSV Writer Code----------------##


import csv
#with open('workspacesdata.csv', 'w', newline='') as csvfile:
with open('workspacesdata.csv', 'w') as fp:
    print('created', workspaces)
    datawriter = csv.writer(csvfile,dialect='excel')
    
    fieldnames=['WorkspaceId', 'DirectoryId', 'UserName', 'IpAddress','State', 'BundleId', 'SubnetId','ComputerName','VolumeEncryptionKey' , 'WorkspaceProperties','RunningMode']
    datawriter = csv.DictWriter(csvfile, fieldnames=fieldnames)
    datawriter.writeheader()
  


##----------------CSV Reader Code----------------##

import os
os.system('start excel.exe workspacesdata.csv')

import os
os.system('start excel.exe workspacesdata.csv')[/color]
Error:
"vpc.py", line 21, in <module> datawriter = csv.writer(csvfile,dialect='excel') NameError: name 'csvfile' is not defined PS D:\Users\username>"
Larz60+ write Sep-23-2022, 04:38 PM:
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.
Made attempt to do this for you. Please use bbcode tags on future posts.
Reply
#4
In new code, change line 24 from: datawriter = csv.DictWriter(csvfile, fieldnames=fieldnames)
to: datawriter = csv.DictWriter(fp, fieldnames=fieldnames)
Reply
#5
import boto3
client = boto3.client('workspaces')
folder = input('directoryId> ')

workspaces = client.describe_workspaces()['Workspaces']
directoryIds = [workspaces['DirectoryId']for workspaces in workspaces]
directoryIds.sort()

for DirectoryIds in folder:
    print(workspaces)

    
   
##----------------CSV Writer Code----------------##


import csv
#with open('workspacesdata.csv', 'w', newline='') as csvfile:
with open('workspacesdata.csv', 'w') as fp:
    print('created', workspaces)
    datawriter = csv.writer(csvfile,dialect='excel')
    
    fieldnames=['WorkspaceId', 'DirectoryId', 'UserName', 'IpAddress','State', 'BundleId', 'SubnetId','ComputerName','VolumeEncryptionKey' , 'WorkspaceProperties','RunningMode']
    datawriter = csv.DictWriter(fp, fieldnames=fieldnames)
    datawriter.writeheader()
  


##----------------CSV Reader Code----------------##

import os
os.system('start excel.exe workspacesdata.csv')


Error:
File "d:\Users\imatt010\Desktop\vpc.py", line 21, in <module> datawriter = csv.writer(csvfile,dialect='excel') NameError: name 'csvfile' is not defined


Output:
D:/Users/imatt010/AppData/Local/Programs/Python/Python310/python.exe d:/Users/imatt010/Desktop/vpc.py directoryId> d-92672c44a1 [{'WorkspaceId': 'ws-0gsp8c21g', 'DirectoryId': 'd-92671ccf44', 'UserName': 'msand149', 'IpAddress': '10.113.98.195', 'State': 'AVAILABLE', 'BundleId': 'wsb-wvlsl0kmt', 'SubnetId': 'subnet-0acf167ed5eaf8207', 'ComputerName': 'EC2AMAZ-72US9NV', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/7bd71746-a7ab-4d91-99dc-367218580a72', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-w48symlvx', 'DirectoryId': 'd-92672eca2c', 'UserName': 'fepps005', 'IpAddress': '10.159.248.251', 'State': 'AVAILABLE', 'BundleId': 'wsb-8vbljg4r6', 'SubnetId': 'subnet-08c10fc6c56006f5c', 'ComputerName': 'WSAMZN-DRDQV134', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/6ea5ddec-f663-4a66-a850-a61f85836cb7', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 50, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-4l4j8kw71', 'DirectoryId': 'd-92672c44a1', 'UserName': 'eliba005', 'IpAddress': '10.159.250.43', 'State': 'AVAILABLE', 'BundleId': 'wsb-8vbljg4r6', 'SubnetId': 'subnet-0eb119c83fcd876b5', 'ComputerName': 'WSAMZN-JM97ED2F', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/b8c6cee2-6eeb-441e-bc8e-d8b8c5469738', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 100, 'ComputeTypeName': 'PERFORMANCE'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-561h0qt8y', 'DirectoryId': 'd-92671ce35c', 'UserName': 'jbusa003', 'IpAddress': '10.113.90.44', 'State': 'AVAILABLE', 'BundleId': 'wsb-9mw5qstcj', 'SubnetId': 'subnet-055c1fd5f0f78926a', 'ComputerName': 'EC2AMAZ-EC8RJR6', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/c0bf7254-4ed0-49db-b068-aa35aead1569', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-91hbn4hwv', 'DirectoryId': 'd-92672ca3ab', 'UserName': 'nflow005', 'IpAddress': '10.159.250.211', 'State': 'AVAILABLE', 'BundleId': 'wsb-b31hkn0hd', 'SubnetId': 'subnet-0bd2f24ad8422306f', 'ComputerName': 'WSAMZN-UI44V8J4', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/520f7329-1a6c-47f9-82ec-37da09216d81', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'PERFORMANCE'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-xvx82z7z8', 'DirectoryId': 'd-92672ca3ab', 'UserName': 'gslag001', 'IpAddress': '10.159.250.232', 'State': 'AVAILABLE', 'BundleId': 'wsb-b31hkn0hd', 'SubnetId': 'subnet-0bd2f24ad8422306f', 'ComputerName': 'WSAMZN-M5LJQOSM', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/520f7329-1a6c-47f9-82ec-37da09216d81', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'PERFORMANCE'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-jl99sthlm', 'DirectoryId': 'd-92671ce35c', 'UserName': 'gorig004', 'IpAddress': '10.113.92.145', 'State': 'AVAILABLE', 'BundleId': 'wsb-9mw5qstcj', 'SubnetId': 'subnet-0df248a17a13690bb', 'ComputerName': 'EC2AMAZ-B9HGV8L', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/e2cf9e85-13aa-4129-b35e-29be08d4a8c9', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-9q0yp939t', 'DirectoryId': 'd-92672eca2c', 'UserName': 'vjone045', 'IpAddress': '10.159.248.126', 'State': 'AVAILABLE', 'BundleId': 'wsb-b31hkn0hd', 'SubnetId': 'subnet-08c10fc6c56006f5c', 'ComputerName': 'WSAMZN-20ISH4MP', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/6ea5ddec-f663-4a66-a850-a61f85836cb7', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-xq2qdvgt1', 'DirectoryId': 'd-92671ce35c', 'UserName': 'mbaoi001', 'IpAddress': '10.113.91.107', 'State': 'AVAILABLE', 'BundleId': 'wsb-9mw5qstcj', 'SubnetId': 'subnet-055c1fd5f0f78926a', 'ComputerName': 'EC2AMAZ-PFE6K8C', 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-gqqf4jbx0', 'DirectoryId': 'd-92671ce35c', 'UserName': 'rroge011', 'IpAddress': '10.113.92.84', 'State': 'AVAILABLE', 'BundleId': 'wsb-8vbljg4r6', 'SubnetId': 'subnet-0df248a17a13690bb', 'ComputerName': 'WSAMZN-SJA7ICMM', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/e2cf9e85-13aa-4129-b35e-29be08d4a8c9', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 50, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-b2hbfj6pp', 'DirectoryId': 'd-92671ce35c', 'UserName': 'simal001', 'IpAddress': '10.113.90.222', 'State': 'AVAILABLE', 'BundleId': 'wsb-9mw5qstcj', 'SubnetId': 'subnet-055c1fd5f0f78926a', 'ComputerName': 'EC2AMAZ-DF2QICP', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/e2cf9e85-13aa-4129-b35e-29be08d4a8c9', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-83p69rk1d', 'DirectoryId': 'd-92671dad88', 'UserName': 'crex001', 'IpAddress': '10.113.48.134', 'State': 'AVAILABLE', 'BundleId': 'wsb-hsqhwwxjz', 'SubnetId': 'subnet-056af6011ea8e94fe', 'ComputerName': 'EC2AMAZ-O889V6D', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/225c3919-c904-4c4c-88b2-b8aff6a3c2e5', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-327hd6ftk', 'DirectoryId': 'd-92672738e7', 'UserName': 'msher032', 'IpAddress': '10.159.24.64', 'State': 'AVAILABLE', 'BundleId': 'wsb-362t3gdrt', 'SubnetId': 'subnet-0c63e957', 'ComputerName': 'WSAMZN-NE8FC4O5', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/6ea5ddec-f663-4a66-a850-a61f85836cb7', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 50, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-xph652g88', 'DirectoryId': 'd-92671dae7d', 'UserName': 'fsier010', 'IpAddress': '10.113.46.198', 'State': 'AVAILABLE', 'BundleId': 'wsb-hsqhwwxjz', 'SubnetId': 'subnet-071e647325ac3750d', 'ComputerName': 'EC2AMAZ-PFV4FFG', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/225c3919-c904-4c4c-88b2-b8aff6a3c2e5', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-fqtph8155', 'DirectoryId': 'd-92671ce35c', 'UserName': 'jduad002', 'IpAddress': '10.113.93.199', 'State': 'AVAILABLE', 'BundleId': 'wsb-9mw5qstcj', 'SubnetId': 'subnet-0df248a17a13690bb', 'ComputerName': 'EC2AMAZ-LA5QENM', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/c0bf7254-4ed0-49db-b068-aa35aead1569', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-k4yx85xw2', 'DirectoryId': 'd-92671ce35c', 'UserName': 'jdela455', 'IpAddress': '10.113.91.29', 'State': 'AVAILABLE', 'BundleId': 'wsb-9mw5qstcj', 'SubnetId': 'subnet-055c1fd5f0f78926a', 'ComputerName': 'EC2AMAZ-ROUT3HC', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/e2cf9e85-13aa-4129-b35e-29be08d4a8c9', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-36n767rfc', 'DirectoryId': 'd-926728f384', 'UserName': 'amelg005', 'IpAddress': '10.159.16.192', 'State': 'AVAILABLE', 'BundleId': 'wsb-8vbljg4r6', 'SubnetId': 'subnet-712b3a38', 'ComputerName': 'WSAMZN-DFNFQ2FN', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/6ea5ddec-f663-4a66-a850-a61f85836cb7', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 50, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-bz46m2bsr', 'DirectoryId': 'd-92671ccf44', 'UserName': 'amonr018', 'IpAddress': '10.113.98.6', 'State': 'AVAILABLE', 'BundleId': 'wsb-wvlsl0kmt', 'SubnetId': 'subnet-00bc82572544985a2', 'ComputerName': 'EC2AMAZ-NKJ1JJP', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/7bd71746-a7ab-4d91-99dc-367218580a72', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-kctzpvr7l', 'DirectoryId': 'd-92671ce35c', 'UserName': 'ttrum003', 'IpAddress': '10.113.93.73', 'State': 'AVAILABLE', 'BundleId': 'wsb-9mw5qstcj', 'SubnetId': 'subnet-0df248a17a13690bb', 'ComputerName': 'EC2AMAZ-7NTK35R', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/c0bf7254-4ed0-49db-b068-aa35aead1569', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-3f6z05rgx', 'DirectoryId': 'd-92671ce35c', 'UserName': 'krafi003', 'IpAddress': '10.113.90.39', 'State': 'AVAILABLE', 'BundleId': 'wsb-9mw5qstcj', 'SubnetId': 'subnet-055c1fd5f0f78926a', 'ComputerName': 'EC2AMAZ-5OKBEUQ', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/e2cf9e85-13aa-4129-b35e-29be08d4a8c9', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-2ptlkm5qv', 'DirectoryId': 'd-92671ce35c', 'UserName': 'mdomi077', 'IpAddress': '10.113.91.208', 'State': 'AVAILABLE', 'BundleId': 'wsb-9mw5qstcj', 'SubnetId': 'subnet-055c1fd5f0f78926a', 'ComputerName': 'EC2AMAZ-T18AKN8', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/c0bf7254-4ed0-49db-b068-aa35aead1569', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-6bw7svsnp', 'DirectoryId': 'd-92672c445d', 'UserName': 'arico027', 'IpAddress': '10.159.250.248', 'State': 'AVAILABLE', 'BundleId': 'wsb-b31hkn0hd', 'SubnetId': 'subnet-0bd2f24ad8422306f', 'ComputerName': 'WSAMZN-T8VRNFTT', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/95d05f8e-7e21-4852-8cb8-f4a8505d8110', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-08h9cjkvt', 'DirectoryId': 'd-92670ed06d', 'UserName': 'vsanc079', 'IpAddress': '10.113.81.161', 'State': 'AVAILABLE', 'BundleId': 'wsb-35gdsrk4x', 'SubnetId': 'subnet-04f8860f4dbcbb4e4', 'ComputerName': 'WSAMZN-J6IHDJ93', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/bef5e0aa-2c8f-4b2d-8c31-9456e5de18ce', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 10, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-h6vs896fs', 'DirectoryId': 'd-92672c44a1', 'UserName': 'achoa004', 'IpAddress': '10.159.250.36', 'State': 'AVAILABLE', 'BundleId': 'wsb-gm4d5tx2v', 'SubnetId': 'subnet-0eb119c83fcd876b5', 'ComputerName': 'WSAMZN-JOSCE5IC', 'VolumeEncryptionKey': 'arn:aws:kms:us-west-2:336694646358:key/95d05f8e-7e21-4852-8cb8-f4a8505d8110', 'UserVolumeEncryptionEnabled': True, 'RootVolumeEncryptionEnabled': True, 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 100, 'ComputeTypeName': 'PERFORMANCE'}, 'ModificationStates': []}, {'WorkspaceId': 'ws-b1t8zwt6b', 'DirectoryId': 'd-926728fc2c', 'UserName': 'drahu001', 'IpAddress': '10.159.24.21', 'State': 'AVAILABLE', 'BundleId': 'wsb-8vbljg4r6', 'SubnetId': 'subnet-0c63e957', 'ComputerName': 'IP-C0A8D2AA', 'WorkspaceProperties': {'RunningMode': 'ALWAYS_ON', 'RootVolumeSizeGib': 80, 'UserVolumeSizeGib': 50, 'ComputeTypeName': 'STANDARD'}, 'ModificationStates': []}]
Reply
#6
As data from Amazon Workspaces is dictionary(nested) as it ordinal coming from Json.
Then structure will be nested,i would take into Pandas and use json_normalize
Here a example in NoteBook.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  tools for writing and reading binary data in files Skaperen 0 1,445 Jun-08-2020, 07:28 PM
Last Post: Skaperen

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020