Book E-commerce Transactions 2018-2019

Columns

• ID: A unique identifier for each record.
• Serial No.: A serial number for the entry.
• Purchase-date: The date and time of purchase in an encoded format.
• Date: The processed date derived from the purchase date.
• Time: The processed time extracted from the purchase date.
• Quarter: The processed quarter with the year, derived from the purchase date.
• Qtr: The processed quarter number from the purchased date.
• Year: The processed year from the purchased date.
• Month: The processed month from the purchased date.
• Date (DD only): The processed day of the month from the purchased date.
• Special Day: Indicates if the purchase occurred on a special event day.
• Online Sale Offers: Notes if any offers were applied to the sale.
• Day: The day of the week when the book was purchased (1 for Monday, 2 for Tuesday, etc.).
• Weekend: Indicates if the purchase day was a Saturday or Sunday.
• Morning: Indicates if the purchase occurred in the morning.
• Afternoon: Indicates if the purchase occurred in the afternoon.
• Evening: Indicates if the purchase occurred in the evening.
• Night: Indicates if the purchase occurred at night.
• Gender: Numerical representation of gender (0 for Male, 1 for Female).
• Customer ID: A unique identifier for each customer.
• Processed Gender: Categorical representation of gender with totals (Male 52%, Female 48%).
• Product-Name: The name of the book sold.
• Item-Status: The status of the item (most common: Shipped, 100%).
• Quantity: The number of items ordered in a single transaction.
• Currency: The currency used for transactions (INR, 100%).
• Item Price: The price at which the item was sold.
• Shipping-Price: The cost of delivery for the item.
• Ship-City: The city to which the item was shipped (e.g., NEW DELHI 6%, BENGALURU 5%).
• Ship-State: The state to which the item was shipped (e.g., MAHARASHTRA 17%, UTTAR PRADESH 10%).
• Ship-Postal-Code: The postal code of the shipping destination.
• Category: The category of the book (e.g., school 37%, competition 25%).
• Total_amount: The total amount, including item price and shipping price.
• Author: The author of the book (e.g., NCERT 46%).
• Publication: The publication house of the book (e.g., National Council of Education Research and Training 39%).
• Profit Percentage (%): The profit percentage for the sale.
• Profit (INR): The profit made in Indian Rupees.
• Cost Price: The cost price of the book.

Distribution

Usage

• Analysing book sales trends over time, by category, and by geographical region.
• Understanding customer purchasing behaviour based on gender, time of day, and special events.
• Evaluating profitability of different book categories, authors, and publications.
• Identifying top-selling products and publications for inventory management and marketing strategies.
• Market research for education, literature, and e-commerce services in India.

Coverage

License

Who Can Use It

• Data analysts for trend identification and statistical modelling.
• E-commerce businesses to optimise sales strategies and product offerings.
• Market researchers for understanding the Indian book market.
• Publishers and authors to gauge market demand and identify successful titles.
• Educational institutions to track book consumption patterns related to school and college curricula.
• Sales and marketing professionals for campaign planning and target audience identification.

Dataset Name Suggestions

• Indian Book Sales Records 2018-19
• Education & Competition Book Sales India
• Book E-commerce Transactions 2018-2019
• Publishing Sales Data India
• Kaggle Book Sales Data

Attributes