Stack Overflow
Stack Overflow

Questions tagged [drop]

468 questions
0
votes
1 answer

Droping rows with outliers from specific columns

I am building a binary classification model on a heavily unbalanced dataset(95% 1s and 5% 0s). I want to drop the rows with outliers and I used the below code: from scipy import stats df=df[(np.abs(stats.zscore(df)) < 3).all(axis=1)] However, this…
dododips
  • 91
  • 1
  • 6
0
votes
1 answer

how can I drag text from one a textbox to another textbox in a userform

I have 20 textboxes in a userform and I want to move the text from textbox1 to textbox5 by dragging and dropping it with the mouse, but I really have no idea how to do this. I am not an experienced programmer in VBA so maybe it is not even possible
Chielmos
  • 65
  • 1
  • 2
  • 7
0
votes
1 answer

pandas dataframe, if condition match and index next to each other: add value and delete the row used

I want to drop queried dataframe - rows and replace it with new data when the index are next to each other. basically adding value i-1 to i. is this possible to be done ? please see the example data below: if i have a data frame as above: i want to…
bmaster69
  • 121
  • 9
0
votes
1 answer

AttributeError: 'NoneType' object has no attribute 'drop'

I'm trying to remove some columns from my dataframe, however I'm just getting this error no matter how hard I try to figure out how to fix it. Could you help me? drop_cols = ['ISO3A código economía declarante', 'ISO3A código economía asociada', …
asairi nava
  • 19
  • 7
0
votes
1 answer

Move a SQL Server 2016 table to another database and access it with a synonym using the original name

For integration purposes I want to move a table to a different database B ( on the same server ) and then create a synonym of the table on the original database A so that all the objects referring to the table can still work as before the move. The…
Paolo Aimetti
  • 1
0
votes
1 answer

Jquery on Drop affects children elements in column

Making a Kanban board with draggable and droppable cards. It works but it also allows you to drop into the children elements and the issue-cards will nest into each other which is not the desired function. How do I drop into .status-column but not…
Rajin Tech
  • 1
0
votes
2 answers

When using pandas, how to drop a row by its values and not by its label?

I am trying to drop certain rows from a CSV file, but not by its label. I need to drop rows with certain values. In this csv file, how would I drop every row with categroy == Physics?
gandalfos
  • 1
0
votes
3 answers

Remove the last column of dataframe in R in a function

I need to remove the last column of 10 dataframes, so I decided to put it in lapply(). I wrote a function to remove the col, like below, remove_col <- function(mydata){ mydata = subset(mydata, select=-c(24)) } and create a mylist <- (data1,…
wawalmx
  • 15
  • 1
  • 4
0
votes
2 answers

Python : Dropping specific rows in a dataframe and keep a specif one

Let's say that I have this dataframe Name = ['ID', 'Country', 'IBAN','ID_info_1', 'Dan_Age', 'ID_info_1','Dan_city','ID_info_1','Dan_country','ID_info_1', 'ID_info_2', 'ID_info_2','ID_info_2', 'Dan_sex', 'Dan_Age', 'Dan_country','Dan_sex' ,…
Maikiii
  • 421
  • 4
  • 13
0
votes
1 answer

WM_DROPFILES not called on x64

How to make drag & drop? On the win32 machine it works without problems but on the x64 the WM_DROPFILES message is not called at all. Where is the problem? static LRESULT CALLBACK WindowProc(HWND hWnd, UINT msg, WPARAM wParam, LPARAM lParam) { …
Gabi Fintescu
  • 35
  • 5
0
votes
2 answers

Removing values of a certain object type from a dataframe column in Pandas

I have a pandas dataframe where some values are integers and other values are an array. I simply want to drop all of the rows that contain the array (object datatype I believe) in my "ORIGIN_AIRPORT_ID" column, but I have not been able to figure out…
user14409786
0
votes
1 answer

Javascript | Counting total and individual scores when dropping div onto other div

I'm working on an HTML/Javascript thingy. It shows a zoo, and you need to drag&drop the right animals(div) in the right cages(div). When you do, it should update the total number of animals in the zoo (it does with this code), and also update…
user13648124
0
votes
1 answer

Tempo tables used on queries running at the same time throwing already exists error

I'm running multiple queries (in diffent sessions) which use the following code, some times in paralell, and I was getting errors saying the temp table already existed. I was under the impression the temp tables would just be using some sort of…
Matias
  • 539
  • 5
  • 28
0
votes
1 answer

LocalStorage - Seperate Selections

"Any optimization suggestions for js localstorage ?" $(function () { $('#selection1').change(function () { localStorage.setItem('todoData', this.value); }); if (localStorage.getItem('todoData')) { …
OVERTYPE
  • 3
  • 2
0
votes
1 answer

a dataframe with several columns having the same column name, how to only keep the first and drop the rest?

I have a df with these columns: Index(['Instrument', 'Date', 'Return on Invst Cap', 'Date', 'Book Value Per Share, Total Equity', 'Date', 'Earnings Per Share Reported - Actual', 'Date', 'Revenue from Business Activities -…
neutralname
  • 383
  • 2
  • 4
  • 11
1 2 3
…
31 32