Baselight

Company Financials Dataset

Test your preprocessing skills with this dataset!!

@kaggle.atharvaarya25_financials

Loading...
Loading...

About this Dataset

Company Financials Dataset

This is a dataset that requires a lot of preprocessing with amazing EDA insights for a company. A dataset consisting of sales and profit data sorted by market segment and country/region.

Tips for pre-processing:

  1. Check for column names and find error there itself!!
  2. Remove '$' sign and '-' from all columns where they are present
  3. Change datatype from objects to int after the above two.
  4. Challenge: Try removing " , " (comma) from all numerical numbers.
  5. Try plotting sales and profit with respect to timeline

Tables

Financials

@kaggle.atharvaarya25_financials.financials
  • 44.94 kB
  • 700 rows
  • 16 columns
Loading...
CREATE TABLE financials (
  "segment" VARCHAR,
  "country" VARCHAR,
  "n__product" VARCHAR  -- Product,
  "n__discount_band" VARCHAR  -- Discount Band,
  "n__units_sold" VARCHAR  -- Units Sold,
  "n__manufacturing_price" VARCHAR  -- Manufacturing Price,
  "n__sale_price" VARCHAR  -- Sale Price,
  "n__gross_sales" VARCHAR  -- Gross Sales,
  "n__discounts" VARCHAR  -- Discounts,
  "n__sales" VARCHAR  -- Sales,
  "n__cogs" VARCHAR  -- COGS,
  "n__profit" VARCHAR  -- Profit,
  "date" TIMESTAMP,
  "month_number" BIGINT,
  "n__month_name" VARCHAR  -- Month Name,
  "year" BIGINT
);

Share link

Anyone who has the link will be able to view this.