notebook.community

Edit and run



In [3]:

    
import pandas as pd
Genesis = pd.read_excel("Bible.xlsx",sheetname="Genesis")
import requests



In [2]:

    
Genesis









    Out[2]:






  
    
      
      Book Name
      1
      2
      3
      4
      5
      6
      7
      8
      9
      ...
      41
      42
      43
      44
      45
      46
      47
      48
      49
      50
    
  
  
    
      0
      Genesis
      31
      25
      24
      26
      32
      22
      24
      22
      29
      ...
      57
      38
      34
      34
      28
      34
      31
      22
      33
      26
    
  

1 rows × 51 columns



In [3]:

    
genesisList = []



In [4]:

    
def ProcessGenesis(Book,Chapter,Verses):
    for thisSet in range(1,Verses+1):
        genesisList.append(Book+str(Chapter)+':'+str(thisSet))



In [5]:

    
for idx,element in enumerate(Genesis.values.tolist()[0]):
    if str(element).isdigit():
        ProcessGenesis('Genesis',idx,element)



In [6]:

    
genesisDictList = []
for element in genesisList:
    genesisDict = {}
    link = 'http://api.biblia.com/v1/bible/content/kjv.text?passage='+element+'&style=bibleTextOnly&key=78107f435755fdf76ac5f8d991664d79&header=[FullVerseRef]'
    genesisDict['link']=link
    genesisDict['passage']=element
    result = requests.get(link)
    genesisDict['passageText']=result.content
    genesisDictList.append(genesisDict)



In [10]:

    
GenesisDF.to_excel("GenesisDF.xlsx")