Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.52 KB | None | 0 0
  1. l = [None] *shape[0]
  2. data["State"] = l
  3. numOfColumns = shape[0]
  4. columns =data.columns
  5. for i in range(shape[0]):
  6. #print(data["Place"][i])
  7. tmpList = data["Place"][i].split(',')
  8.  
  9. #print(tmpList[len(tmpList)-1])
  10. if "-" in tmpList[len(tmpList)-1]:
  11. newStringRow = data.loc[i]
  12. newTmpList=tmpList[len(tmpList)-1].split('-')
  13. #print(newTmpList, i)
  14. #print(data.loc[i])
  15. length =len(newTmpList)
  16. statLen =len(newTmpList)
  17. isFirstTime =True
  18. while(length):
  19. if isFirstTime:
  20. newRow = data.iloc[i][0]
  21. newRow=str(tmpList[0])+"," +newTmpList[length-1]
  22. data["Place"][i]=newRow
  23. data["State"][i]=newTmpList[length-1]
  24. data["Pop"][i]=int(data["Pop"][i]/statLen)
  25. length=length-1
  26. # print(newRow,1)
  27. isFirstTime=False
  28. else:
  29. numOfColumns=numOfColumns+1
  30. newRow = data.iloc[i][0]
  31. newRow=str(tmpList[0])+"," +newTmpList[length-1]
  32. length=length-1
  33. # print(newRow,2)
  34. newStringRow["Place"]=newRow
  35. newStringRow["State"]=newTmpList[length-1]
  36. newStringRow["Pop"]=int(data["Pop"][i]/statLen)
  37. #print(newStringRow)
  38. data= data.append(newStringRow,ignore_index=numOfColumns)
  39. else:
  40. data["State"][i]=tmpList[len(tmpList)-1]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement