PromptBase
Upgrade
Close icon
General
Home
Marketplace
Create
Hire
Login
Chat
Sell
Explore

Prompt Details

Model
Chat - GPT-3.5 (gpt-3.5-turbo)
Token size
76 ($0.00010 / call)
Example input
[data source]: CSV file, Excel sheet [data processing task]: Describe the specific data processing task to be performed. [output format]: Specify the format in which the processed data should be saved.
Example output
Certainly! Here's a Python script that reads data from a CSV file, filters records based on a certain condition, and saves the processed data to a new Excel sheet using the Pandas library. Make sure you have the Pandas library installed in your Python environment. ```python import pandas as pd # Define the input CSV file path and the output Excel file path input_csv_file = "input_data.csv" output_excel_file = "output_data.xlsx" # Define the condition to filter records (e.g., filtering records where 'column_name' is greater than 50) condition_column = 'column_name' condition_value = 50 # Read data from the CSV file into a Pandas DataFrame data = pd.read_csv(input_csv_file) # Filter the records based on the condition filtered_data = data[data[condition_column] > condition_value] # Create a Pandas ExcelWriter object to write to an Excel file with pd.ExcelWriter(output_excel_file, engine='xlsxwriter') as writer: # Write the filtered data to a new Excel sheet filtered_data.to_excel(writer, sheet_name='filtered_data', index=False) # Print a message to indicate the process is complete print("Data processing and saving to Excel completed.") ``` Make sure to customize the `input_csv_file`, `output_excel_file`, `condition_column`, and `condition_value` according to your specific use case. This script reads the data from the input CSV file, filters the records based on the condition you specify, and then saves the filtered data to a new Excel sheet. It uses the `xlsxwriter` engine for Excel output, so make sure you have it installed as well. You can install it using `pip install XlsxWriter`. Don't forget to install the necessary libraries and modify the file paths and conditions to suit your specific requirements.
🤖 GPT

Data Processing With Python Pandas

Add to Cart
Instant accessInstant access
Usage rightsCommercial use
Money-back guaranteeMoney‑back
By purchasing this prompt, you agree to our terms of service
GPT-3.5-TURBO
Tested icon
Guide icon
Free credits icon
Data Processing with Python Pandas
...more
Added over 1 month ago
Report
Browse Marketplace