Skip to content

Instantly share code, notes, and snippets.

@EscVector
Last active January 31, 2022 14:56
Show Gist options
  • Save EscVector/5712be95b804ae32fb3587baffdda2a5 to your computer and use it in GitHub Desktop.
Save EscVector/5712be95b804ae32fb3587baffdda2a5 to your computer and use it in GitHub Desktop.
OCI Features By Region
# pip install pandas
# pip install openpyxl
# pip install xlsxwriter
import pandas as pd
url='https://www.oracle.com/cloud/data-regions/#government'
df = pd.read_html(url)
writer = pd.ExcelWriter('OCI-Cloud-Active-Features.xlsx', engine='xlsxwriter')
sheets = {0:"North America DS",1:"North America OCI",2:"EMEA DS",3:"EMEA OCI",4:"LAD DS",5:"LAD OCI",6:"APAC DS",7:"APAC OCI",8:"Dedicated",9:"GovCloud"}
for count, frame in enumerate(df):
df[count].to_excel(writer, sheet_name = sheets[count])
writer.save()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment