Dataset: Company Financials Dataset

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:

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

Tables

Financials

@kaggle.atharvaarya25_financials.financials

43.88 KB
700 rows
16 columns


CREATE TABLE financials (
  "segment" VARCHAR,
  "country" VARCHAR,
  "n__product" VARCHAR,
  "n__discount_band" VARCHAR,
  "n__units_sold" VARCHAR,
  "n__manufacturing_price" VARCHAR,
  "n__sale_price" VARCHAR,
  "n__gross_sales" VARCHAR,
  "n__discounts" VARCHAR,
  "n__sales" VARCHAR,
  "n__cogs" VARCHAR,
  "n__profit" VARCHAR,
  "date" TIMESTAMP,
  "month_number" BIGINT,
  "n__month_name" VARCHAR,
  "year" BIGINT
);