Zoe | 快捷上传文件到七牛云 for macOS

I have the following tables:

customer:

id customer_number company firstname lastname account_manager_email email comments terms tax_id_number lead_source default_catalog credit_limit 99453 C00123456 Serenity Inc. Malcom Reynolds jim.smith@example.com mal@example.com The cap'n 1 NULL NULL 12345 NULL 99468 C00123456 Serenity Inc. Zoe Washburne jim.smith@example.com zoe@example.com NULL 1 NULL NULL NULL NULL 99960 C00123456 Serenity Inc. Hoban Washburne jim.smith@example.com wash@example.com NULL 1 NULL NULL NULL NULL 100088 C00123456 Serenity Inc. Inara Serra jim.smith@example.com inara@example.com NULL 1 NULL NULL 12345 NULL

customer_address:

id company street city state_abbreviation postcode telephone firstname lastname created_at 133996 Serenity, Inc 123 Any St. Anytown AX 12345 123-456-7890 Malcom Reynolds 2017-05-08 12:45:53.000 134452 Serenity, Inc 123 Any St. Anytown AX 12345 123-456-7890 Accounts Payable 2017-05-09 10:19:59.000 134961 Serenity, Inc 123 Any St. Anytown AX 12345 123-456-7890 REF 987654321 2017-05-09 10:19:59.000 134962 Serenity, Inc 123 Any St. Anytown AX 12345 123-456-7890 REF 192837465 2017-05-09 10:19:59.000 133995 Serenity, Inc 123 Any St. Anytown AX 12345 123-456-7890 Accounts Payable 2017-05-09 10:19:59.000 133669 Serenity, Inc 123 Any St. Anytown AX 12345 123-456-7890 REF 123456789 2017-05-18 10:29:42.000 133667 Serenity, Inc 123 Any St. Anytown AX 12345 123-456-7890 Accounts Payable 2017-05-18 07:56:45.000 133666 Serenity, Inc 123 Any St. Anytown AX 12345 123-456-7890 Accounts Payable 2017-05-31 07:56:46.000 133626 Serenity, Inc 123 Any St. Anytown AX 12345 123-456-7890 Accounts Payable 2017-06-16 12:45:08.000 133668 Serenity, Inc 123 Any St. Anytown AX 12345 123-456-7890 REF PO 2017-06-16 12:45:08.000

I'm running this query to generate a CSV that I can use to import the data into another system:

...

I need a little help with two tables issues: How to achieve simple horizontal union of 2 tables? Like this:

...

I have a table called flux with :

...

I try to remove duplicates words in multiples categories. For this, I have an object named users which contains the words that user sends.

And I use a new object that contains the words found in dictionary with its category.

...

I have a pyspark dataframe and want to add a column that adds values from a list in a repeating fashion. If this were just python, I would probably use itertools' cycle function. I don't know how to do this in pyspark.

...

I'm trying to make a query whit a 'cast group by' - output.

But not quit sure how to tackle this or even to start (I think i need cast and group by but not sure).

I have some code below which hopefully explains what I'm trying to do. Could somebody help me to make a query to have the correct output?

...

This is an exercise that is not part of the training on the site, I do not understand why when I want to display the return value of the energy method of my satellite class, I receive an address on the console.

...

I'm trying to bind some data to an Adaptive Card Choice Set using templating. I've been experimenting in the designer with an element like this:

...

I have a data frame called df2 that looks like this:

And I want to replace all the Model names that contain the string "ZOE" or another key word with just "ZOE", given that it is of Make "RENAULT" or another make. So, for example, I want ZOE DYNMAIQUE INTENS AUTO -> AUTO, and if the Model does not contain a string with the characters "ZOE" I want it to keep its model name.

I am new to python, and I have tried the below code with no luck.

...