Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- l = [None] *shape[0]
- data["State"] = l
- numOfColumns = shape[0]
- columns =data.columns
- for i in range(shape[0]):
- #print(data["Place"][i])
- tmpList = data["Place"][i].split(',')
- #print(tmpList[len(tmpList)-1])
- if "-" in tmpList[len(tmpList)-1]:
- newStringRow = data.loc[i]
- newTmpList=tmpList[len(tmpList)-1].split('-')
- #print(newTmpList, i)
- #print(data.loc[i])
- length =len(newTmpList)
- statLen =len(newTmpList)
- isFirstTime =True
- while(length):
- if isFirstTime:
- newRow = data.iloc[i][0]
- newRow=str(tmpList[0])+"," +newTmpList[length-1]
- data["Place"][i]=newRow
- data["State"][i]=newTmpList[length-1]
- data["Pop"][i]=int(data["Pop"][i]/statLen)
- length=length-1
- # print(newRow,1)
- isFirstTime=False
- else:
- numOfColumns=numOfColumns+1
- newRow = data.iloc[i][0]
- newRow=str(tmpList[0])+"," +newTmpList[length-1]
- length=length-1
- # print(newRow,2)
- newStringRow["Place"]=newRow
- newStringRow["State"]=newTmpList[length-1]
- newStringRow["Pop"]=int(data["Pop"][i]/statLen)
- #print(newStringRow)
- data= data.append(newStringRow,ignore_index=numOfColumns)
- else:
- data["State"][i]=tmpList[len(tmpList)-1]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement