无法在datafram中以自定义方式存储输出

2024-05-23 20:15:24 发布

您现在位置:Python中文网/ 问答频道 /正文

我已经用python创建了一个脚本来解析一些url并将它们存储在一个数据帧中。我的剧本可以做到。然而,这并不是我所期望的那样。你知道吗

我试过:

import requests
from bs4 import BeautifulSoup
import pandas as pd

base = 'http://opml.radiotime.com/Search.ashx?query=kroq'

linklist = []

r = requests.get(base)
soup = BeautifulSoup(r.text,"xml")
for item in soup.select("outline[type='audio'][URL]"):
    find_match = base.split("=")[-1].lower()
    if find_match in item['text'].lower():
        linklist.append(item['URL'])

df = pd.DataFrame(linklist, columns=[find_match])
print(df)

电流输出:

0      http://opml.radiotime.com/Tune.ashx?id=s35105
1      http://opml.radiotime.com/Tune.ashx?id=s26581
2  http://opml.radiotime.com/Tune.ashx?id=t122458...
3  http://opml.radiotime.com/Tune.ashx?id=t132149...
4  http://opml.radiotime.com/Tune.ashx?id=t131867...
5  http://opml.radiotime.com/Tune.ashx?id=t120569...
6  http://opml.radiotime.com/Tune.ashx?id=t125126...
7  http://opml.radiotime.com/Tune.ashx?id=t131068...
8  http://cdn-cms.tunein.com/service/Audio/nostre...
9  http://cdn-cms.tunein.com/service/Audio/notcom...

预期产出(如有可能,我也希望剔除指数):

0      http://opml.radiotime.com/Tune.ashx?id=s35105
1      http://opml.radiotime.com/Tune.ashx?id=s26581
2      http://opml.radiotime.com/Tune.ashx?id=t122458
3      http://opml.radiotime.com/Tune.ashx?id=t132149
4      http://opml.radiotime.com/Tune.ashx?id=t131867
5      http://opml.radiotime.com/Tune.ashx?id=t120569
6      http://opml.radiotime.com/Tune.ashx?id=t125126
7      http://opml.radiotime.com/Tune.ashx?id=t131068
8      http://cdn-cms.tunein.com/service/Audio/nostre
9      http://cdn-cms.tunein.com/service/Audio/notcom

Tags: importcomidhttpbasecmsservicecdn
1条回答
网友
1楼 · 发布于 2024-05-23 20:15:24

可以对齐。要摆脱索引,请在写入csv时删除它

df.style.set_properties(**{'text-align': 'left'})
df.to_csv(r'Data.csv', sep=',', encoding='utf-8-sig',index = False ) 

相关问题 更多 >