学习Python纪录Day22 - 用Kaggle上的dataset当例子

显示工作表每一列的值

wb = load_workbook("Top 10 most Streamed.xlsx")
ws = wb.active
for row in ws.rows:
	for cell in row:
		print(cell.value, end= "  ")
	print()
wb.close()

显示工作表每一栏的值

wb = load_workbook("Top 10 most Streamed.xlsx")
ws = wb.active
for column in ws.columns:
	for cell in column:
		print(cell.value, end= "  ")
	print()
wb.close()

读取指定储存格的资料

利用栏和列座标来读取指定储存格的资料

ws = wb['Top 10 most Streamed']
v = ws["A1"].value
print("A1： ", v)
v = ws["B1"].value
print("B1： ", v)
v = ws["C1"].value
print("C1： ", v)
wb.close()

心得：
今天学习了如何用python读取现有的excel资料表，我在kaggle上找了一笔比较有兴趣的Dataset「Top 100 most streamed songs on spotify」来当例子练习，利用今天学到的一些方法可以帮助我们整理出想看到的特定内容。

** Top 100 most streamed songs on spotify**
原网址：https://www.kaggle.com/pavan9065/top-100-most-streamed-songs-on-spotify/version/1

(方便呈现完整的画面，所以今天练习的例子只有取原档案的前十笔资料)