Crea una funcion que reciba 2 dataframes de pyspark, df_properties con las columnas property_id, site, plan_codename, url, info_date y df_leads con las columnas columnas pl_received_at, property_id y portal_name entre otras. Cree una columna nueva llamada number_leads en df_properties donde ponga cuantos registros existen en la tabla df_leads por cada fecha info_date de df_properties. La busqueda debe ser comparando df_properies.info_date == df_leads.pl_received_at, df_properies.site== df_leads.portal_name y df_properies.property_id_leads== df_leads.property_id_leads

def join_df(df_properties, df_leads):
  df_properties = df_properties.withColumn("number_leads", count(df_leads.pl_received_at == df_properties.info_date & df_leads.portal_name == df_properties.site & df_leads.property_id == df_properties.property_id))
  return df_properties

Python

Generate More

Experience Our AI Studio

Access all features through one powerful interface — lightning-fast, incredibly intuitive, and designed for productivity.

Smart workflows

Real-time collaboration

Customizable workspace

One-click exports

Launch Studio

Feature Preview

Generate

More than just a code generator. A tool that helps you with a wide range of tasks. All in one place.

Function from Description: Generate a function just by describing what is needs to do. Choose of many programming languages.
Text Description to SQL Command: Create a SQL command from a description.
Translate Languages: Translate code to any programming language.
Generate HTML from Description: Generate small HTML from Description.
Code to Explanation: Any code explained in plain english.
Fix invalid Code: To spot a missing character somewhere can be frustrating. This feature will help you to fix it.
Get Test for Code: This feature will help you to create tests for your code.
Class from Description: Generate a class just by describing what is needs to do. Choose of many programming languages.
Regex from Description: Create a regex from a description like "check for email".
Regex to Explanation: Create a plain english explanation from a regex.
Git Command from Description: Find the Git Command you are looking for from a description.
Linux Command: Get the linux command from a description.
Function from Docstring: Provide a docstring to generate the actual function.
Add typing to code: This feature will help you to add typing to your code.
Get Language from Code: Get the programming language from a code.
Time complexity: Get time complexity.
CSS from Description: Generate CSS from Description.
Meta Tags from Description: Generate Meta Tags from a Description.

Want to kickstart your project?Use the new AI Studio to create your code

Get chatting now