- android - 多次调用 OnPrimaryClipChangedListener
- android - 无法更新 RecyclerView 中的 TextView 字段
- android.database.CursorIndexOutOfBoundsException : Index 0 requested, 光标大小为 0
- android - 使用 AppCompat 时,我们是否需要明确指定其 UI 组件(Spinner、EditText)颜色
我正在尝试打印 target_playlist
中的值。问题是我想按 percentuali
列对 target_playlist
中的值进行排序,我使用了 target_playlist.sort_values('percentuali', inplace=True, ascending=False)
在 sort_values
函数之前,结果:
print("{}".format(target_playlist['percentuali'][i]))
是:
0.7010264012452779
0.19662758090847976
0.6508863154849628
0.557740362863367
0.47418798688188313
0.6634307395184526
0.17661982395954637
0.6334661569944786
0.5226247859195567
0.37647399781797003
0.6107562358792401
0.10866013071895426
0.6259167928556538
0.5107723732317271
0.5107723732317271
0.440188723891383
0.473270990299173
0.5807994015581672
0.45540535868625753
0.4156854080449265
0.5659237264842225
0.5942257114281826
0.5763053500588216
0.43676171660260443
0.6947640279542424
0.37155299947773396
0.6055124707313475
0.6642522917728619
0.6339323841512609
0.6836084778718268
0.4585485761594801
0.7687767193517359
0.7739306342996543
0.6792746883779797
0.5688985142793829
0.5763507447689178
0.6265388222033668
0.5262211637961803
0.631776719351736
0.7016345319242638
0.6549247063300238
0.6218895455057429
0.3926510809451985
0.5081035167373568
0.6149459682682933
0.44069739392952245
0.46799465192894985
0.69161263493496
0.5534053586862575
0.6968509819258842
0.4988988577428972
0.5059165111353879
0.7355655050414504
0.6792746883779797
0.4401208506283063
0.49320548887003335
0.5112768045242271
0.7361528565218765
0.2329438202247191
0.6123902228073447
0.49864712823852325
0.6909989415739581
0.6754433860184025
0.566520509644565
0.37663089180304893
0.6529677236233883
0.6089596366830047
0.7687767193517359
0.6101347817993262
0.7559795411177228
而当我在调用 sort_values
后打印值时,它们是:
Titolo: Possibili Scenari, Artista: Cesare Cremonini, Probabilita: 0.7559795411177228
Titolo: Shallow, Artista: Lady Gaga, Probabilita: 0.7559795411177228
Titolo: To the Trees, Artista: An Early Bird, Probabilita: 0.7559795411177228
Titolo: If You Wanna Love Somebody - Acoustic, Artista: Tom Odell, Probabilita: 0.7559795411177228
Titolo: Happier - Acoustic, Artista: Ed Sheeran, Probabilita: 0.7559795411177228
Titolo: Lie With Me, Artista: Josiah and the Bonnevilles, Probabilita: 0.7559795411177228
Titolo: Jubilee Road, Artista: Tom Odell, Probabilita: 0.7559795411177228
Titolo: I'll Never Love Again - Film Version, Artista: Lady Gaga, Probabilita: 0.7559795411177228
Titolo: Rise - Acoustic, Artista: Jonas Blue, Probabilita: 0.7559795411177228
Titolo: Hold My Girl, Artista: George Ezra, Probabilita: 0.7559795411177228
Titolo: Love Someone, Artista: Lukas Graham, Probabilita: 0.7559795411177228
Titolo: Angels, Artista: Tom Walker, Probabilita: 0.7559795411177228
Titolo: These Days (feat. Jess Glynne, Macklemore & Dan Caplen) - Acoustic, Artista: Rudimental, Probabilita: 0.7559795411177228
Titolo: Just For Tonight - Acoustic, Artista: James Bay, Probabilita: 0.7559795411177228
Titolo: Perfect, Artista: Ed Sheeran, Probabilita: 0.7559795411177228
Titolo: No Roots, Artista: Joshua Hyslop, Probabilita: 0.7559795411177228
Titolo: Slide, Artista: James Bay, Probabilita: 0.7559795411177228
Titolo: Be Your Man, Artista: Rhys Lewis, Probabilita: 0.7559795411177228
Titolo: No Matter What, Artista: Calum Scott, Probabilita: 0.7559795411177228
Titolo: Woes, Artista: Tom Rosenthal, Probabilita: 0.7559795411177228
Titolo: Barbed Wire (Acoustic), Artista: Tom Grennan, Probabilita: 0.7559795411177228
Titolo: Stay Awake with Me, Artista: Dan Owen, Probabilita: 0.7559795411177228
Titolo: Spent So Long, Artista: Jamie Harrison, Probabilita: 0.7559795411177228
Titolo: Tummy, Artista: Tamino, Probabilita: 0.7559795411177228
Titolo: LOVISA, Artista: FELIX SANDMAN, Probabilita: 0.7559795411177228
Titolo: Girl - Acoustic, Artista: SYML, Probabilita: 0.7559795411177228
Titolo: Party Of One (feat. Sam Smith), Artista: Brandi Carlile, Probabilita: 0.7559795411177228
Titolo: Electricity - Acoustic, Artista: Silk City, Probabilita: 0.7559795411177228
Titolo: Leftovers, Artista: Dennis Lloyd, Probabilita: 0.7559795411177228
Titolo: Hand That You Hold, Artista: Dan Owen, Probabilita: 0.7559795411177228
Titolo: Company (feat. Molly Hammar), Artista: Paul Rey, Probabilita: 0.7559795411177228
Titolo: Too Good At Goodbyes - Edit, Artista: Sam Smith, Probabilita: 0.7559795411177228
Titolo: Need You Now - Acoustic, Artista: Dean Lewis, Probabilita: 0.7559795411177228
Titolo: Such A Simple Thing, Artista: Ray LaMontagne, Probabilita: 0.7559795411177228
Titolo: Acoustic, Artista: Billy Raffoul, Probabilita: 0.7559795411177228
Titolo: Don’t Matter To Me, Artista: Drake, Probabilita: 0.7559795411177228
Titolo: when the party's over, Artista: Billie Eilish, Probabilita: 0.7559795411177228
Titolo: Someone You Loved, Artista: Lewis Capaldi, Probabilita: 0.7559795411177228
Titolo: Collide, Artista: Tom Speight, Probabilita: 0.7559795411177228
Titolo: Fading Into Grey - Acoustic, Artista: Billy Lockett, Probabilita: 0.7559795411177228
Titolo: Never Let You Go (feat. John Newman) - Acoustic Version, Artista: Kygo, Probabilita: 0.7559795411177228
Titolo: T-Shirts, Artista: James Smith, Probabilita: 0.7559795411177228
Titolo: In My Head, Artista: Peter Manos, Probabilita: 0.7559795411177228
Titolo: Where Were You In The Morning?, Artista: Shawn Mendes, Probabilita: 0.7559795411177228
Titolo: come out and play, Artista: Billie Eilish, Probabilita: 0.7559795411177228
Titolo: Tear Me Down, Artista: Paul Rey, Probabilita: 0.7559795411177228
Titolo: Come As You Are, Artista: Imaginary Future, Probabilita: 0.7559795411177228
Titolo: Consequences - orchestra, Artista: Camila Cabello, Probabilita: 0.7559795411177228
Titolo: All I Am - Acoustic, Artista: Jess Glynne, Probabilita: 0.7559795411177228
这是我正在处理的程序的一部分
import tkinter as tk
from tkinter import font as tkfont
import pandas as pd
from sklearn.model_selection import train_test_split
from sklearn.tree import DecisionTreeClassifier
import spotipy
import spotipy.util as util
from numpy import integer
from tkinter import Radiobutton
sp = spotipy.Spotify()
from spotipy.oauth2 import SpotifyClientCredentials
from sklearn.neighbors import KNeighborsClassifier
from sklearn.metrics import accuracy_score
from sklearn.ensemble import RandomForestClassifier
from sklearn.cluster import KMeans
import itertools
import threading
import time
import sys
from operator import itemgetter, attrgetter, methodcaller
target_playlist = pd.DataFrame(newPlaylist_features)
if(algoritmo_scelto==1):
pred = c.predict(target_playlist[features])
p = c.predict_proba(target_playlist[features])
if(algoritmo_scelto==2):
pred = knn.predict(target_playlist[features])
p = knn.predict_proba(target_playlist[features])
if(algoritmo_scelto==3):
pred = forest.predict(target_playlist[features])
p = forest.predict_proba(target_playlist[features])
if(algoritmo_scelto==4):
pred = k_means.predict(target_playlist[features])
p = k_means.predict_proba(target_playlist[features])
likedSongs = 0
i = 0
for prediction in pred:
target_playlist['percentuali'] = p[i][1]
print("{}".format(target_playlist['percentuali'][i]))
i = i +1
target_playlist.sort_values('percentuali', inplace=True, ascending=False)
i=0
for prediction in pred:
if(prediction == 1):
print ("Titolo: " + target_playlist["song_title"][i] + ", Artista: "+ target_playlist["artist"][i] + ", Probabilita: {} ".format(target_playlist["percentuali"][i]))
likedSongs= likedSongs + 1
i = i +1
我哪里错了?
最佳答案
在此循环中,您将 "target_playlist['percentuali']"
系列设置为单个值:
i = 0
for prediction in pred:
target_playlist['percentuali'] = p[i][1]
print("{}".format(target_playlist['percentuali'][i]))
i = i +1
由于 "target_playlist['percentuali'] = p[i][1]"
将 "p[i][1]"
作为值应用于每一行.
如本例所示:
>>> for i in [0, 1, 2]:
... print(i)
... df['this'] = i
...
0
1
2
>>> df
id col_1 col_2 col_3 this
0 1 blue 15 True 2
1 2 red 25 False 2
2 3 orange 35 False 2
3 4 yellow 24 True 2
4 5 green 12 True 2
我不知道对象 p
但您应该将结果转换为 pd.Series
。您可以将那个整个循环修改为如下所示:
target_playlist['percentuali'] = pd.Series(item[1] for item in p)
print(target_playlist['percentuali'])
在您对 DataFrame 调用 sort_values
后,您的值将不会按降序打印,因为您是按索引 引用行,例如(0, 1, 2)
.
您可以通过重置索引来快速修复,请参阅下面的示例:
>>> df.sort_values('col_2', inplace=True, ascending=False)
>>> df
id col_1 col_2 col_3
2 3 orange 35 False
1 2 red 25 False
3 4 yellow 24 True
0 1 blue 15 True
4 5 green 12 True
>>> df['col_2'][0]
15
>>> df.reset_index(inplace=True)
>>> df['col_2'][0]
35
您可以像这样遍历行,而不是通过索引进行引用:
for _, row in df.iterrows():
print("Title: {}, Artist: {}, Probability: {}".format(
row['song_title'], row['artist'], row['percentuali']
))
关于python - 为什么 "sort_values"不能正常工作?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/54113268/
我想知道这两段代码之间的区别是什么? New_Series = pd.Series(df['avg']).sort(axis=0, ascending=False,
我不知道我的代码有什么问题 import pandas as pd import numpy as np woe = [1.1147295474833758,0.364043491078754,-0.
我已经看到很多关于基于 pandas 列名称排序的建议,但我正在尝试基于列索引进行排序。 我已经包含了一些代码来演示我正在尝试做什么。 import pandas as pd df = pd.Data
我知道 sort_index() 可以让我按索引对 df 进行排序,但我想知道 sort_values() 是否也可以按索引排序(无需重置索引)? 最佳答案 不,如果不先将索引转换为列(可能使用 re
我正在处理一个数据框,我想在其中显示某些值的百分比。我将它们计算为十进制值,然后应用格式字符串将它们转换为百分比。当数据框转换为百分比时,它无法正确地对百分比进行排序。 d = {'name': ['
我想通过 pandas 对 pyhon 中的嵌套字典进行排序。 import pandas as pd # Data structure (nested list): # { # category
for i in str_list: #str_list is a set contain some strings df.loc[i].sort_values(by = 'XXX') *
我正在尝试使用 pandas sort_values() 函数对 datafarame 进行排序,但返回的结果以一种奇怪的方式排序,如所附图像 所示 最佳答案 问题是列Citation是数字的字符串表
我是 pandas 的新手,在编程环境中处理表格数据。我按特定列对数据框进行了排序,但 Pandas 吐出的答案并不完全正确。 这是我使用的代码: league_dataframe.sort_valu
我正在尝试打印 target_playlist 中的值。问题是我想按 percentuali 列对 target_playlist 中的值进行排序,我使用了 target_playlist.sort_
我有一个数据框,我想在其中一个列(即日期)上排序但是我有一个在索引上运行的循环( while i
此问题已解决。“Env”(“Env”)中有一个看不见的空间。下面的代码是正确的。 问题: 我不明白有关 sort_values 的错误消息。下面是打印的数据框。 print(df)
我有一个数据框,其中列名是时间(0:00、0:10、0:20、...、23:50)。现在,它们按字符串顺序排序(所以 0:00 是第一个,9:50 是最后一个)但我想按时间对它们进行排序(所以 0:0
问题: 如何根据下面在 top_5 变量中捕获的 sort_values 标准向 plot 添加水平线。: 数据: 这是 data 的一部分在 CSV 中: 这是当前情节。 axnum = today
dataset = pd.read_csv("dataset.csv").fillna(" ")[:100] dataset['Id']=0 dataset['i']=0 dataset['j']=0
大家好,我试图到处寻找这个问题,但我找不到解决方案。如果你能帮助我,我会很高兴。 所以,基本上我有这个数据集: df = pd.DataFrame({"col1": ['xxx', 'xxx', 'x
我有一个df: Date Symbol Person 0 2019 Q3 A Bob 1 2019 Q3 A Jon 2 2019 Q3
我有以下数据子集,我需要按升序对 Education 列进行排序;从 0 到 17。 我尝试了以下代码但没有成功。 suicide_data.sort_index(axis=0, kind='merg
Python Pandas 提供了两种对 DataFrame 进行排序的方法: sort_values (或已弃用 sort ) sort_index 这两种方法有什么区别? 最佳答案 由于问题已更新
在工作中,我们最近升级到 pandas 0.20,我有一个使用 sort 排序的数字列表(但是不再支持此功能,我在尝试 sort_values 时收到上述消息)。 numbers = [1, 3, 4
我是一名优秀的程序员,十分优秀!