How do I use pandas to find a specific value?

pandas
6
Excel

Jun.21,2022

Let me give you an example. Suppose you have imported data from excel and are DataFrame objects.
you can use the DataFrame.loc object to solve (note the difference from the DataFrame.iloc object)

>>> index=[4, 5, 6, 7, 8] -sharp 
>>> columns=[120, 140, 160, 180] -sharp 
>>> a = pd.DataFrame(index=index, columns=columns, data=np.random.randn(5, 4)) -sharp data
>>> a
        120       140       160       180
4 -1.893583 -1.877188  1.531316  1.468032
5 -0.051771 -0.752350  0.771171 -0.662293
6 -0.252470 -0.084280  0.357515 -0.832810
7  0.112660 -0.559447  0.573227  0.385083
8  1.086797 -1.722506  1.963318  1.362636
>>> -sharp 8, 120
>>> d = input(':')
:8
>>> g = input(':')
:120
>>> a.loc[d, g]
1.0867967045350686

finally got it

import pandas as pd
import numpy as np
df=open('C:/Users/xxxxxxx/.xlsx','rb') -sharp'rb'
df=pd.read_excel(df)
-sharpprint(df.head())
dt=open('C:/Users/xxxxxxx/new_file.csv','rb') -sharp
dt=pd.read_csv(dt)
prs=lambda x:120 if x<140 else (140 if x<160 else (160 if x<180 else 180))
age=lambda x:40 if x<50 else (50 if x<60 else (60 if x<70 else 70))
dgc=lambda x:4 if x<5 else (5 if x<6 else (6 if x<7 else (7 if x<8 else 8)))
ndt = pd.DataFrame() -sharpdataframe
for i in range(1,len(dt)): -sharp
    fx=df[(df['']==dt.iloc[i,:][1])&(df['']==age(dt.iloc[i,:][2]))&(df['']==dt.iloc[i,:][9])&(df['']==dt.iloc[i,:][10])&(df['']==dgc(dt.iloc[i,:][17]))]
    rsk=fx[prs(dt.iloc[i,:][22])]
    v=dt.iloc[i,:].copy() -sharp.copy()
    for x in rsk:
        v['']=x
        ndt=ndt.append(v) -sharp
        print(':%.2f %%' %(i/len(dt)*100))
ndt.to_csv('file.csv',encoding='utf_8_sig') -sharp
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1c20bf6-3351f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1c20bf6-3351f.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?