Search: "CSV import"

#data #csv #data cleaning

Clean and Prepare Dataset - Python

Write Python code to clean and prepare a messy dataset for analysis. Handle: 1) ...

#data #Python #pandas

👁 23 views

data Beginner

ChatGPT prompt for cleaning messy CSV data before analysis

Act as a data analyst helping me prepare a messy CSV file for analysis. I will ...

👁 21 views

#Python #pandas #data cleaning

Python Pandas: Data Cleaning and Transformation Workflow

I have a dataset ([CSV/Excel/database] file) with the following issues: [describ...

👁 21 views

data Advanced

Survey Data Analysis Pipeline with Python

Act as a data analyst. Write a complete Python pipeline to analyze survey data f...

#data #survey analysis #Python

👁 16 views

data Advanced

ETL Pipeline Design for Data Warehouse

Design an ETL (Extract, Transform, Load) pipeline for loading data from [source ...

#data #etl #pipeline

👁 16 views

excel advanced

Excel Power Query Data Transformation Pipeline

Help me build an Excel Power Query transformation pipeline. My raw data source i...

#power query #M code #data transformation

👁 16 views

data advanced

R Programming: Statistical Analysis for Business Data

Act as a data scientist and R programming expert. Help me perform statistical an...

#data #r #statistics

👁 15 views

Pandas Cleanup Pipeline for a Messy Real-World CSV

Below is a sample of a messy CSV (10 rows shown). Build a pandas cleaning pipeli...

#data #pandas #csv

👁 15 views

#data cleaning #csv #pandas

ChatGPT prompt for creating a data cleaning pipeline for messy CSV files

Act as a senior data engineer who specializes in data quality and ETL pipelines....

excel Advanced

ChatGPT prompt for creating Excel macros to automate repetitive report formatting

Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA...

#excel #vba #macros

coding Intermediate

Python Script to Parse and Analyze CSV Data

Write a Python script that reads a CSV file named "data.csv", performs analysis,...

#coding #python #csv

#pandas #EDA #data analysis

Python Pandas Data Analysis Pipeline Exploratory Analysis

Write a Python data analysis script using Pandas for exploratory data analysis (...

excel advanced

Excel Power Pivot Data Model for Cross-Table Business Analysis

Build a complete Excel Power Pivot data model for multi-table business analysis....

#excel #power-pivot #dax

#power query #CSV import #data transformation

excel Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#data #Google Sheets #dashboard

Google Sheets Dashboard with Automated Data Import

Act as a Google Sheets expert. Create a complete marketing dashboard in Google S...

#python #web scraping #beautifulsoup

coding Intermediate

ChatGPT prompt for building a Python web scraper with error handling and rate limiting

Act as a senior Python developer specializing in web scraping and data collectio...

data advanced

ETL Pipeline Design for Data Warehouse

Design an ETL (Extract, Transform, Load) pipeline for loading data from [source ...

#data #etl #pipeline

#python #web-scraping #beautifulsoup

coding intermediate

Python Web Scraper with Pagination and Rate Limiting

Write a Python web scraper for [target website type] using requests and Beautifu...

excel advanced

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl

Data Cleaning Strategy and Python Script Generator

Help me clean and prepare a messy dataset for analysis. Dataset details: Data s...

#data #cleaning #python

#power-bi #dashboard #dax

Power BI Dashboard Design: Best Practices for Business Intelligence

Help me design an effective Power BI dashboard. My situation: Data source: [EXC...

#data cleaning #CSV #pandas

Data Cleaning Checklist for Messy CSV and Excel Datasets

Create a systematic data cleaning checklist and workflow for a messy dataset in ...