I’d like to gather some lecturer info and export it into csv. I read some article and tutorial using python. The code looks like this
from selenium import webdriver from webdriver_manager.chrome import ChromeDriverManager import pandas as pd from bs4 import BeautifulSoup driver = webdriver.Chrome(ChromeDriverManager().install()) url = "https://uin-suka.ac.id/id/page/detil_dosen/197606110000002301" driver.get(url) soup = BeautifulSoup(driver.page_source, 'lxml') df = pd.read_html(str(soup)) print(df)
and the output look like this
0 1 2 0 Nama : Dr. Nina Mariani Noor, SS., MA. 1 Program Studi : Interdisciplinary Islamic Studies 2 Fakultas : Pascasarjana 3 Jenis Pegawai | Status : Pegawai Tetap BLU | Aktif Mengajar 4 Jabatan Akademik | Golongan : Lektor | III/C 5 Email : - 6 Pendidikan Terakhir : S3 Process finished with exit code 0
the csv table i created look like this
the problem is, how can i pull the second column and put it into csv as row?
This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.