主页 / user-11626909

Sharif's questions

Martin Hope
Sharif
Asked: 2024-12-18 02:30:22 +0800 CST
  • 7

mutate()我正在尝试使用包中的、across()和Winsorize()函数对数据框中的许多（并非全部）列进行 WinSort 化DescTools。我收到以下错误消息 -

Error in `mutate()`:
ℹ In argument: `across(...)`.
Caused by error in `across()`:
! Can't compute column `drat`.
Caused by error in `Winsorize()`:
! unused arguments (na.rm = TRUE, probs = c(0.01, 0.99))
Backtrace:
 1. mtcars %>% ...
 3. dplyr:::mutate.data.frame(...)
 4. dplyr:::mutate_cols(.data, dplyr_quosures(...), by)
 6. dplyr:::mutate_col(dots[[i]], data, mask, new_columns)
 8. mask$eval_all_mutate(quo)
 9. dplyr (local) eval()

我尝试了很多方法修复它，但都没有成功。我使用的是 R 4.4.1、dplyr 1.1.4、DescTools 0.99.58。下面是我的代码 -

library(tidyverse)
library(DescTools)

mtcars = as_tibble(mtcars)
mtcars = mtcars %>% 
  mutate(across(c(drat, qsec), ~Winsorize(., na.rm = TRUE, probs = c (0.01, 0.99))))
Martin Hope
Sharif
Asked: 2024-11-22 12:46:13 +0800 CST
  • 8

我有这样的小事 -

# A tibble: 11 × 1
   messycol                   
   <chr>                      
 1 ""                         
 2 ""                         
 3 ""                         
 4 ""                         
 5 ""                         
 6 ""                         
 7 "|15|16|32|33|36|39|40|41|"
 8 "|15|16|32|39|"            
 9 "|10|29|32|38|39|40|"      
10 "|32|39|"                  
11 ""

输出dput()在这里 -

structure(list(messycol = structure(c("", "", "", "", "", "", 
"|15|16|32|33|36|39|40|41|", "|15|16|32|39|", "|10|29|32|38|39|40|", 
"|32|39|", ""), label = "Noteffectiveaccountingrule reason keys", format.sas = "$")), row.names = c(NA, 
-11L), class = c("tbl_df", "tbl", "data.frame"))

我想创建一个虚拟变量，如下所示messycol- 如果messycol包含 15 或 16，则为 1，否则为 0。请注意，中的空白值messycol应保持原样 -" "

所以，我的预期输出是这样的 -

# A tibble: 11 × 2
   messycol                         DUMMY                 
   <chr>                      
 1 ""                               ""                      
 2 ""                               ""                          
 3 ""                               ""                           
 4 ""                               ""                          
 5 ""                               ""                         
 6 ""                               ""                         
 7 "|15|16|32|33|36|39|40|41|"       1
 8 "|15|16|32|39|"                   1     
 9 "|10|29|32|38|39|40|"             0    
10 "|32|39|"                         0              
11 ""                               ""
Martin Hope
Sharif
Asked: 2024-09-23 02:26:38 +0800 CST
  • 5

我想从 BeautifulSoup 对象创建一个数据框 -

import pandas as pd
from requests import get
from bs4 import BeautifulSoup
import re

# Fetch the web page
url = 'https://carbondale.craigslist.org/search/apa#search=1~gallery~0~0'
response = get(url) # link exlcudes posts with no picures
page = response.text

# Parse the HTML content
soup = BeautifulSoup(page, 'html.parser')

# Information I need 
list_url = []
title = []
location = []
price = []

# I run the following 
list_url = [a['href'] for a in soup.select('a[href^="https"]')]
title = [x.text for x in soup.find_all(class_="title")]
location = [x.text for x in soup.find_all(class_="location")]
price = [x.text for x in soup.find_all(class_="price")]

但我面临的问题是，对于某些类别（例如，标题或位置），缺少一些元素，因此，当我尝试创建数据框时，它会显示错误，因为None值不相等，因为所有列表的大小都不相等。您可以使用该len()函数检查列表的大小。实际上，我想在数据框的列中包含“无”一词来表示缺失的元素。

python
Martin Hope
Sharif
Asked: 2023-10-11 01:00:08 +0800 CST
  • 5

我.xlsb通过使用pd.read_excel()函数将文件导入到python（pycharm IDE）中；但是，在导入.xlsb文件之前，我将其转换为.xlsx格式，然后导入。请注意，我没有使用，.xlsb因为我遇到了有关日期变量解析的问题。

现在我需要提取 float64 类型变量的第一个数字，然后运行以下代码 -

app_invoice = app_invoice \
    .assign (FIRSTDIGIT = int(str(app_invoice['INVOICE_AMOUNT'][:1]))
            )

但它不会提取第一个数字。然后我只是通过运行以下代码来检查问题 -

str(app_invoice['INVOICE_AMOUNT'])

但它的输出看起来像这样。我不知道为什么会\n1这样等等

0         13611.34\n1         91000.00\n2           159.97\n3          1300.00\n4  
```
python