title: Python for loop implementation when I make dataframe with Pandas module
body: <p>I am interested in learning python but I learned python program for 2 weeks. I coded this program for 2 days but I can't find how I should do. This is the code that I did as follows.</p>
  
  <p>===========================================================================</p>
  
  <pre><code>import requests
  
  from bs4 import BeautifulSoup
  
  import pandas as pd
  
  df = pd.read_csv("C:/Users/Administrator/PycharmProjects/naver_datalab.csv",sep=",", encoding ='CP949')
  
  df1 = df['키워드']
  
  for i in df1:
  
  
  r=requests.get("https://search.shopping.naver.com/search/all.nhn?query=" + str(i) + "&amp;cat_id=&amp;frm=NVSHATC")
  c=r.content
  soup=BeautifulSoup(c,"html.parser")
  
  
  all=soup.find("li",{"class":"snb_all on"}).text
  
  all2=all.replace("전체","").replace("\s", "").replace(" ", "").replace("\n", "")
  
  df['ProductN'] = all2
  
  
  print(df)
  </code></pre>
  
  <p>============================================</p>
  
  <p>First, I read csv file with Pandas and dataframe is as follows.</p>
  
  <pre><code> df = pd.read_csv("C:/Users/Administrator/PycharmProjects/naver_datalab.csv",sep=",", encoding ='CP949')
  </code></pre>
  
  <p>키워드</p>
  
  <p>0  모기퇴치기</p>
  
  <p>1  벌레퇴치기</p>
  
  <p>2  해충퇴치기</p>
  
  <p>3  전기모기퇴치기</p>
  
  <p>================================================================================
  The expecting result page is as follows.</p>
  
  <p>print(df) -> enter key</p>
  
  <p>키워드         ProductN</p>
  
  <p>0  모기퇴치기     132,877</p>
  
  <p>1  벌레퇴치기     127,250</p>
  
  <p>2  해충퇴치기     136,109</p>
  
  <p>3  전기모기퇴치기  125,307</p>
  
  <p>===============================================================================
  However, actual result page of <code>print(df)</code> is as follows. </p>
  
  <p>C:\Users\Administrator\PycharmProjects\untitled\venv\Scripts\python.exe </p>
  
  <p>C:/Users/Administrator/PycharmProjects/untitled/test1.py</p>
  
  <pre><code>   키워드 ProductN
  </code></pre>
  
  <p>0    모기퇴치기  132,877</p>
  
  <p>1    벌레퇴치기  132,877</p>
  
  <p>2    해충퇴치기  132,877</p>
  
  <p>3  전기모기퇴치기  132,877</p>
  
  <pre><code>   키워드 ProductN
  </code></pre>
  
  <p>0    모기퇴치기  127,250</p>
  
  <p>1    벌레퇴치기  127,250</p>
  
  <p>2    해충퇴치기  127,250</p>
  
  <p>3  전기모기퇴치기  127,250</p>
  
  <pre><code>   키워드 ProductN
  </code></pre>
  
  <p>0    모기퇴치기  136,109</p>
  
  <p>1    벌레퇴치기  136,109</p>
  
  <p>2    해충퇴치기  136,109</p>
  
  <p>3  전기모기퇴치기  136,109</p>
  
  <pre><code>   키워드 ProductN
  </code></pre>
  
  <p>0    모기퇴치기  125,307</p>
  
  <p>1    벌레퇴치기  125,307</p>
  
  <p>2    해충퇴치기  125,307</p>
  
  <p>3  전기모기퇴치기  125,307</p>
  
  <p>Process finished with exit code 0</p>
  
  <p>================================================================================
  I don't know how I can fix this result. I just assume that from the for loof, there are some mis-implementation.
  Please let me know how can I fix this result. </p>