双11狂欢大促

盲盒赢 定制羽绒服

开启惊喜盲盒,抽取你的专属好礼

— 惊喜奖品抢先看 —

求助:涉及到for循环的concat如何使用

qq_40246532 qq_40246532 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区

 

import pandas as pd
df = pd.DataFrame()
url_list = ['http://www.espn.com/nba/salaries/_/seasontype/4']
for i in range(2, 13):
    url = 'http://www.espn.com/nba/salaries/_/page/%s/seasontype/4' % i
    url_list.append(url)
#遍历网页中的table读取网页表格数据
for url in url_list:
    df = df.append(pd.read_html(url), ignore_index=True)
#列表解析:遍历dataframe第3列,以子字符串$开头
df = df[[x.startswith('$') for x in df[3]]]
print(df)
df.to_csv('NBA.csv',header=['RK','NAME','TEAM','SALARY'], index=False)

 

运行后出错,提示如下:

D:\Python\pythonProject\venv\Scripts\python.exe "D:/Admin/Python数据分析从入门到精通/1. 示例源码--Python数据分析从入门到精通/03/18/demo.py"
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
D:\Admin\Python数据分析从入门到精通\1. 示例源码--Python数据分析从入门到精通\03\18\demo.py:9: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df = df.append(pd.read_html(url), ignore_index=True)
Empty DataFrame
Columns: [0, 1, 2, 3]
Index: []

 

...全文

相关推荐

for循环中如何正确使用字符串拼接

众所周知,常见的拼接方式有:StringBuffer,StringBuilder,concat,+,StringUtils.join 那么通过如下代码,看一下在for循环中,不同的字符串拼接方式,到底哪种效率最高?  package com.test.stringjoin; import org.apache.commons.lang3.StringUtils; public class Test { public static void main(String[] args) { long t1 = System.currentTimeMillis();

weixin_38672815

Mysql的GROUP_CONCAT()函数使用方法

语法: GROUP_CONCAT([DISTINCT] expr [,expr …][ORDER BY {unsigned_integer | col_name | expr}[ASC | DESC] [,col_name …]][SEPARATOR str_val]) 下面演示一下这个函数,先建立一个学生选课表student_courses,并填充一些测试数据。 SQL代码 复制代码 代码如下:CREATE TABLE student_courses (          student_id INT UNSIGNED NOT NULL,          courses_id INT UN

weixin_38607554

MySQL中的CONCAT函数使用教程

使用MySQL CONCAT()函数将两个字符串连接起来,形成一个单一的字符串。试试下面的例子: mysql> SELECT CONCAT('FIRST ', 'SECOND'); +----------------------------+ | CONCAT('FIRST ', 'SECOND') | +----------------------------+ | FIRST SECOND | +----------------------------+ 1 row in set (0.00 sec) 了解CONCAT函数更详细,考虑EMPLOYEE_TBL表具有以下记录

weixin_38690508

java中concat()方法的使用说明

主要介绍了java中concat()方法的使用说明,具有很好的参考价值,希望对大家有所帮助。一起跟随小编过来看看吧

weixin_38545768

44_特征融合concat和add的区别1

1. 做的是对应通道对应位置的值的相加,通道数不变 2. 描述图像的特征个数不变,但是每个特征下的信息却增加了 1. 做的是通道的合并,通道数变多了 2. 描述

东方捕
评论
收藏 已收藏
分享
返回顶部