amdforlive

I have a dataframe like this :

​

I want to select all the row with Name is NaN, then apply lambda function to get a string from last name to replace the NaN value.

I have try:

df.loc[df['Name'].isnull() ] = df.loc[df['Name'].isnull()].apply( lambda x  : (x['last name'].split(' ')[0]) ,axis=1)
                                                                                               

But it return error : Must have equal len keys and value when setting with an iterable

I am doing something like the following :

Testing['new_value'] = Testing.apply(lambda x  : convert(x['value']),axis=1)

I am using a lambda function to create a new column. And pandas remind me to I should Try using .loc[row_indexer,col_indexer] = value instead

​

How should I code to avoid this reminder ?

I am working on a scrapy project. I want to know how to pass a argument to a spider class.

I want to pass the keyword argument (file_path='C:\\') to the dictionary variable in my spider class.

I try the following two methods but didn't work.

Method 1:

class MySpider(scrapy.Spider):
    name = 'MySpider'

    custom_settings = { 'FEED_URI': self.file_path }

Method 2:

class MySpider(scrapy.Spider):
    name = 'MySpider'

    def __init__(self, file_path ='', **kwargs):
        custom_settings = {
            'FEED_URI' :  file_path + '.json'
        }
        super(MySpider,self).__init__(**kwargs)

​

I have read the [https

I have a instances deploy on GCP. I connect to it using the web browser like ssh. As I didnt install putty in my local computer. The question is what is the easiest way to upload a text file to the server ?

​

My text file is around 500mb.

I am using GCP to create 50 instances of squid. But the price is huge. Is it possible to set one single instances with 50 different outbound IP address for my clients ?

I want to build a program to to compare the similarity of a input phrase with a array of short phrases.

And find the most similar one.

Should I start from extract the keyword from the input first then compare with the array ?

One of the characteristic of the input and data array is all of them are noun phrases like animal name, household item and place name etc. Would it help me to exploit ?

I have a csv tabular data around 3M rows, in following structure:

​

Some of the raw data are corrupted. Like the first two row which have a number store in list type in which I am only interest to the number inside. All I want is to extract the number 978 , 2341 out of the square brackets. The whole column are read as object to dataframe initially, and now I want to extract the number and cast whole column back to number.

I have try to use a for loop with condition to convert the item one by one but it is very slow.

Is there any more efficient method ?

I have a 3gb DB in mongodb. But, I am not quite familiar with the javascript like query in mongo, so I loaded the Dateset to pandas dataframe. It takes endlessly.

So how should I speed up the process? or any other solutions rather than mongodb should I use ?

List_finish = [1,2]
List_Raw =[1,2,3,4,5]
List_unfinished = []


for raw in List_Raw:
    if raw not in List_finish:
        List_unfinished.append(raw)

I want to get a List_unfinished with [3,4,5] .

The above for loop is very slow in large list. Any efficient method ?

I have tried turn it on and off. But it doesnt work most of the time.

Is there anyway to do so ?

I just set up my first ubuntu vm on EC2 all using default setting, except I add a in-bounding rule to allow my ip address access on all protocol.

I didnt set key pair. Because I dont know how to connect via SSH.

Then, I try to connect the VM via the browser-based SSH connection. It only show Black Screen and no response.

​

Whats wrong with that ?

I find that a code like the following in the creation page of instances.

POST https://www.googleapis.com/compute/v1/projects/helpful316/zones/us-central1-a/instances
{
  "kind": "compute#instance",
  "name": "instance-1",
  "zone": "projects/helpful-wa",
  "machineType": "projects/helpful-6/zones/us-central1-a/machineTypes/n1-standard-1",
  "displayDevice": {
    "enableDisplay": false
  },
  "metadata": {
    "kind": "compute#metadata",
    "items": []
  },
  "tags": {
}

I am not familar with the linux and api. Is the above code used to create instances ?

I know how to write request in python so can I use the above code to

I very new to mongodb. I have used mongodb to store some data which have text and image local path. I hope to find a simple gui which can display the data in table view and have some simple sorting function.