[Python] After scraping data from website and converting csv, excel don't show rows except...

url ="https://www.dsebd.org/top_20_share.php"
r =requests.get(url)
soup = BeautifulSoup(r.text,"lxml")
table = soup.find("table",class_="table table-bordered background-white shares-table")
top = table.find_all("th")
header = []
for x in top:
ele = x.text
header.append(ele)

df = pd.DataFrame(columns= header)
print(df)

row1 = table.find_all("tr")
row2 =[]
for r1 in row1[1:]:
ftd= r1.find_all("td")[1].find("a", class_="ab1").text.strip()
data=r1.find_all("td")[1:]
r2 = [ele.text for ele in data]
r2.insert(0,ftd)
l= len(df)
df.loc[l]= r2
print(df)

df.to_csv("top_20_share_value_22.csv")


How to see / make data visible after converting to csv and view via excel?

I have gone through above mentioned code.

Continue reading...