Stack Overflow
Stack Overflow

Questions tagged [drop]

468 questions
2
votes
1 answer

Prevent users from removing MySQL triggers set by different user

Im currently setting up a database system with a lot of different users, having access to only limited views, and tables of the database system. Now I need to create several triggers as the root user, to prevent some actions. But all the users…
Yorick
  • 51
  • 8
2
votes
1 answer

Is it possible to transfer ownership back automatically?

If ownership from one struct is (partially) transferred to another struct (e.g. by copying part of its fields), how can it be "transferred back", as in how can I drop the former struct? Consider this code: struct User { active: bool, …
black
  • 1,151
  • 3
  • 18
  • 46
2
votes
2 answers

Pandas Merge and Complete rows with same id

Here is an extract of my dataframe : ID LU MA ME JE VE SA DI 200 B B B 201 C C C C C 211 A 211 D D D 211 B 213 A A 216 K K K K 216 K 217 B B B B B I have some rows with same ID and…
bptste
  • 25
  • 4
2
votes
2 answers

How to show the number of dropped observations in R?

For different analysis, I use different samples, but I need to make it transparent how the sample came about. Stata shows me "XX observations dropped" after each drop command. Is there a way to get R to state the number of observations dropped in…
KPol
  • 23
  • 4
2
votes
1 answer

Dragged item going faster than cursor

I'm trying to write some code to create a drag and drop minigame. So far I'm having a problem with the touchable part of the code. When I added the draggable option (with cursor only) it worked perfectly. But I tried to add some touchable code (to…
Voctor
  • 47
  • 7
2
votes
1 answer

Drop rows based on column values in Dask

I am using dask to read a large csv file. I wanted to drop a few rows based on one column value. If for that particular column the row value is empty I want to remove the entire row. I tried using .dropna: df = df.dropna(subset=['tier1_name'],how =…
krk
  • 37
  • 4
2
votes
1 answer

Mongo shell - TypeError - not a function

So I'm trying to tidy up my database. I logged into shell, made a show collections request and then I wanted to delete some of those. I used db.collection_name.drop() and it helped for a while. A dozen of collections were deleted successfully. But…
Dmitriy M
  • 297
  • 1
  • 2
  • 7
2
votes
1 answer

Pandas dataframe drop by column

I want to filter a dataframe based on values in a column. Here is how the df looks: lead_snp Set_1 Set_2 Set_3 Set_4 Set_5 ... Set_4995 Set_4996 Set_4997 Set_4998 Set_4999 Set_5000 0 1:2444414 8 7 1 10 17 ... 16 …
gokberk
  • 47
  • 7
2
votes
1 answer

Drop Non English Rows Pandas

df.review: de la nada mi ya no se escucha I tried to set it up It is a good product The aim is to remove non-English rows. I tried this and this but none work. The below code label all the rows as English mistakenly. from langdetect import…
SaNa
  • 333
  • 1
  • 3
  • 13
2
votes
0 answers

Unable to drop Serverless database in Synapse Studio

From Synapse Studio, I created the database [tbfb_Test_ExtermalTables] in the serverless Built-in SQL pool, but can't delete/drop it now. There is no connection to this database. Monitor > SQL Request > all are either Complete or Failed. drop…
user13175610
  • 21
  • 1
2
votes
1 answer

Dropping multiple columns in a pandas dataframe between two columns based on column names

A super simple question, for which I cannot find an answer. I have a dataframe with 1000+ columns and cannot drop by column number, I do not know them. I want to drop all columns between two columns, based on their names. foo = foo.drop(columns =…
Anakin Skywalker
  • 2,400
  • 5
  • 35
  • 63
2
votes
2 answers

Drop a few tables that have similar names by using wildcard

I want to drop all tables starts name with "__am" in BigQuery dataset. Before this I'm using this query, but it takes a long query to do that. DROP TABLE `sales.__am-123`; DROP TABLE `sales.__am-134`; DROP TABLE `sales.__am-145`; DROP TABLE…
dan
  • 199
  • 1
  • 1
  • 11
2
votes
2 answers

Dropping rows in a certain time interval

So we have a Pandas DataFrame with certain values at certain times. For example: @ts @value Glucose Diff smooth_diff new P N C1 C2 135 2021-10-29 11:16:00 167 167.0 -3.0 15.45 15.45 17.95 17.45 NaN…
BroodjeBal
  • 53
  • 5
2
votes
3 answers

How to remove columns based on user input in python (pandas)?

How to write code so that the dataframe remove column based on user input of the column name? amend_col= input(" would u like to 'remove' any column?:") if amend_col == "yes": s_col= input("Select the column you want to add or remove:") if…
keenQuestions
  • 35
  • 1
  • 8
2
votes
1 answer

mod_rewrite Fast and low resource way to block the request

I use following rule to block requests based on some User Agents using modRewrite RewriteCond %{HTTP_USER_AGENT} ^.*(SCspider|PetalBot|ZyBorg).*$ [NC] RewriteRule ^.*$ - [F,L] OR RewriteCond %{HTTP_USER_AGENT} ^.*(SCspider|PetalBot|ZyBorg).*$…
Farhad Sakhaei
  • 894
  • 10
  • 28
1 2
3
…
31 32