Product Sales Dataset Csv

,This dataset is a repository for the results of all packaging reviews of shipping containers (cartons) reviewed by Quality Assurance staff for product arriving at an LCBO warehouse. In particular, I want to find sales volume for several different tobacco and e-cig products over time. Now we are done with pre-processing our data set. If others are also updating values in your csv file then it might be useful to add some comments into the file so that. 2 columns of data are pure text, the other 6 are purely numeric. 8 GB database (MySQL or CSV) of over 1. Product reviews: a pretty big dataset with millions of customer reviews from products on Amazon. Carriage provides a complete range of services relating to funerals, burials and cremations, including the use of funeral homes and motor vehicles, the performance of cemetery interment services and the management and maintenance of cemetery. Virtual Machines Provision Windows and Linux virtual machines in seconds; Windows Virtual Desktop The best virtual desktop experience, delivered on Azure; Azure SQL Database Managed, intelligent SQL in the cloud. 5 Million Records) - Sales Disclaimer - The datasets are generated through random logic in VBA. Save it again at once, making sure that you specify UTF-8 encoding. Flexible Data Ingestion. bfriday = pd. Data has been excluded or redacted from the publication in line with guidance issued by the. This dataset consists of reviews from amazon. Below is the list of csv files the dataset has along with what they include:. Generate a bar graph of. csv; train_ver2. DataBank An analysis and visualisation tool that contains collections of time series data on a variety of topics. 5 7-Jan,236. To do the same we have written a function with takes the dataset and header names as input and add the header names to the dataset. 00 As part of HarrisX’s estimates for iPhone sales (Oct-Dec 2018) and projections for new flagship iPhone sales (Jan-Mar 2019), we are releasing the respondent-level data behind this analysis. 3 5-Jan,185. The AWS Public Dataset Program covers the cost of storage for publicly available high-value cloud-optimized datasets. So, when the user has selected a sales order we should be able to send the information about the current sales order to either the customer or a alternate e-mail address. Wholesale customers Data Set Download: Data Folder, Data Set Description. Each transaction (row) has the list of product_id purchased by a client (File: TDB_product. This site provides data in xls, csv, html, json, xml. These are not real sales data and should not be used for any other purpose other than testing. csv dataset Note The data format in product-sales. It is generally a good idea to combine both sets into one. Dark Net Markets (DNM) are online markets typically hosted as Tor hidden services whose users transact in Bitcoin or other cryptocoins, usually for drugs or other illegal/regulated goods; the most famous DNM was Silk Road 1, which pioneered the business model. sourced from CSV load you need to Include the new field on your CSV sourced from Salesforce then on the Dataflow you have to add the new column sourced from an external dataset, Integration System Pushing the data to wave should add the new column. Python package for dynamic system estimation of time series - blue-yonder/pydse. This dataset is about 1. Note that these data are distributed as. Below is a sample of a report built in just a couple of minutes using the Blank Canvas app. Reviews include product and user information, ratings, and a plaintext review. To fix it, open the file in a text editor. If the product CSV file was produced by exporting your products from Shopify, then you don't need to do anything because your images are already on your website. 9 MB) Previous versions of this data are available. Create a Dataset Array from a File; On this page; Create a Dataset Array from a Tab-Delimited Text File. This typical sales dataset contains sales and profit figures for years, products, and the countries and market segments where these products are sold. Don't forget that you can always share your Python notebook as part of a Mode report, and co-workers viewing the report can always download the results as a CSV on their own. If your question cannot be answered via our web site, You can give us a call at: 1-877-SPIRES-1(1-877-774-7371). If your CSV does not have the correct column headers or if the CSV is not created correctly, it can lead to inaccurate data being imported. Files with the. uk — With over 50 000 datasets, you'll have no trouble finding what you need to know about the UK government. Note: If for some reason you are having problems with the CSV file – post a question in the course, and in the meantime use the Excel file (the 3rd file listed below). { "@context": "https://project-open-data. In this example, We are going to round all the records present in [Standard Cost], and [Sales Amount] columns. This dataset is a digital representation of lands set aside as Crown Reserve within the State of Western Australia. Download data for total, female and male population aged 15-64 in dta, xls, or csv format. Remember, to import CSV files into Tableau, select the "Text File" option (not Excel). The product-sales. The companies that started data collection with paper ledgers and ended with. loadtxt('sales. ) on diverse product categories. Companies with reportable ingredients in their products must submit information to the California Safe Cosmetics Program if the company: Has annual aggregate sales of cosmetic products of one million dollars or more, and; Has sold cosmetic products in California on or after January 1, 2007. If you use this data set, please acknowledge the funding support and operational support for STAR. This means: (1) Do not do anything ''funny'' with the dataset; (2) Do not try to break the anonymization; (3) Do not share that data. If you are using Processing, these classes will help load csv files into memory: download tableDemos. A project can have multiple datasets, each used for a different AI Platform Data Labeling Service request. For our experiment, we will need a dataset. 5 MB) Download Retail Sales Index time series in csdb format structured text (2. Import the data items into the dataset resource. Taxation statistics: an overview of the income and tax status of Australian individuals, companies, partnerships, trusts and funds for 2014-15. A look at the big data/machine learning concept of Naive Bayes, and how data sicentists can implement it for predictive analyses using the Python language. This article is the ultimate list of open datasets for machine learning. MovieLens 1B Synthetic Dataset MovieLens 1B is a synthetic dataset that is expanded from the 20 million real-world ratings from ML-20M, distributed in support of MLPerf. Note: If for some reason you are having problems with the CSV file - post a question in the course, and in the meantime use the Excel file (the 3rd file listed below). csv dataset read file using pandas, but when attempting to bring the dataset into RM, the import chokes. dat Vars are (year, year. uk to help you find and use open government data. For JSON, XML, XLS etc. world has helped make data accessible across our teams from marketing to product to sales. Forum Thread - Empty Dataset when Exporting to CSV or XLSX - Xamarin. This sounds bold and grandiose, but the biggest barriers to this are incredibly simple. csv") bfriday. This resource will be updated on annual basis. Click here to load an example. Count the number of processors. The lm function really just needs a formula (Y~X) and then a data source. Here you can find symbols and pictograms for all transport modes to use in your apps, products and other projects. Print the structure of the data. See this post for more information on how to use our datasets and contact us at [email protected] Download Sample CSV. For example, If we want to compare the sales between different product categories, product colour we can use this R bar chart. round Function Example 4. Your colleague wants the information about these sales representatives in comma-separated value (CSV) format so that the data can be viewed and manipulated in a spreadsheet program. From the Datasets panel, select Download from the dataset's menu, and select whether to generate a CSV file or Wdesk spreadsheet. This data depicts a typical product sale system, storing and tracking customers, products, customer orders, warehouse stock, shipping, suppliers, and even employees and their sales territories. csv', delimiter=",") Either way will work, if you have the correct format for the data. If you have content that you wish to keep, you should make a copy of it before that date. We acknowledge the extensive help received from Jerome Lauret, Wei-ming Zhang and their colleagues. Note: The details below depict our latest Data Discovery update, to be released on April 1st, 2019. Hello Yan Li, Thanks for your answer. The datasets are meant to be used strictly for the purposes of the class project and nothing else. Find CSV files with the latest data from Infoshare and our information releases. Julian McAuley, UCSD. yml') data = cat. For example, If we want to compare the sales between different product categories, product colour we can use this R bar chart. Abbreviation to define. To import data from a CSV file into MATLAB use the “readtable” function. · Import the Microsoft. Each line has a minimum of 11 fields, which are preformatted and comma separated. New motor vehicle sales Number of units and total sales of new motor vehicles by vehicle type and origin of manufacture, monthly. Go to menu File: Import: Comma Delimited (CSV) to open CSV dialog. We are going to use this dataset as a training model in our project. Statewide contracts are written agreements between the State of Oklahoma and contractors that have been selected to provide a variety of products and services to state and local entities. This article shows how to connect to CSV from Jaspersoft Studio as a standard JDBC data source with the CData JDBC Driver for CSV. There are situations where sampling is appropriate, as it gives a near representations of the underlying population. There are total insured value (TIV) columns containing TIV from 2011 and 2012, so this dataset is great for testing out the comparison feature. It's like they read our sales team wish-list and delivered a product that answered almost all our needs. THIS IS THE SERVER CODE PART. , Database,,,,, 99,LCBO Quality Services-Quality Assurance Invoices,Record of Quality Assurance invoices issued to LCBO suppliers. Sales, customer service, supply chain and logistics, manufacturing… no matter which department you're in, you more than likely care about backorders. If you are using D3 or Altair for your project, there are builtin functions to load these files into your project. Of the 44 fields, 9 will be used in 9 separate rank queries (i. Create a Dataset Array from a File; On this page; Create a Dataset Array from a Tab-Delimited Text File. These 998 transactions are easily summarized and filtered by transaction date, payment type, country, city, and geography. You will use the standard Jaspersoft wizards to build SQL queries to CSV. When the import wizard opens it should give you a preview of the data and in the top right is a box which asks you how many header lines there are. Balance of payments (BOP) statistics for OECD member and non-member countries according to BPM6 classification are included in this dataset. This dataset describes the monthly number of sales of shampoo over a 3 year period. CSV files can be used with most any spreadsheet program, such as Microsoft Excel or Google Spreadsheets. Wool Fiber Dataset. loadtxt('sales. The Machine Learning Toolkit contains datasets that were provided by others. Datasets - Coffee - World and regional statistics, national data, maps, rankings. Does your app need to store Comma Separated Values or simply. Read dataset from csv file and generate pandas dataframes. Datasets also allow you to perform searches based on the data and group together desired results from different origins to assist you with analysis. This resource will be updated on annual basis. It includes 6. Clicking that tile will take you to the report for the dataset you just added). Your Sales Director has just asked you to generate additional revenues of $1,500,000 before September 01, 2007. Note: If for some reason you are having problems with the CSV file - post a question in the course, and in the meantime use the Excel file (the 3rd file listed below). Read dataset from csv file and generate pandas dataframes. The data format in product-sales. Simply click on the Export Button in the lower left corner and the file will appear in a web broswer such as Google Chrome the bottom left of the Interface. Stores are identified by Store IDs in all three datasets. 75 inches wide by 3. Predict the online sales of a consumer product based on a data set of product. A Purchase Order is a document sent by the Council to a supplier indicating types, quantities, and agreed prices for products or services. Microsoft Data Access Components (MDAC) is a framework of technologies that provides programmers with a uniform and consistent way to develop applications that can access almost any data store. Create and add a. This layer is a subset of the zoning boundaries for the City and County of Denver, Colorado to reflect the zone districts in the ‘new code’ that permit farmers markets as a temporary, seasonal use. Here you can find symbols and pictograms for all transport modes to use in your apps, products and other projects. The datasets below may include statistics, graphs, maps, microdata, printed reports, and results in other forms. This site provides data in xls, csv, html, json, xml. Using this model, BigMart will try to understand the properties of products and stores which play a key role in increasing sales. Month,ProductSales 1-Jan,271 2-Jan,150. It includes 6. One solution is to use an Excel Macro to export the data using double quotes. Image Analysis and Video Analysis` image` python` code` flickr` matlab` recognition. 5 12-Jan,190. If you know the tasks that machine learning should solve, you can tailor a data-gathering mechanism in advance. Import SAS and STATA datasets as data matrices. We will import data from a local file sample-data. data_source(). Thank you for your useful replies Diego. Real or quasi-real data is best. You can also export orders based on the date they were. Balance of payments (BOP) statistics for OECD member and non-member countries according to BPM6 classification are included in this dataset. We are Ordnance Survey Licensed Partners and also resellers of map datasets from around the world. Business and Finance` retail` finance` sales` store` Code for querying and downloading Flickr images. We do not store this data nor will we use this data to email you, we need it to ensure you've read and have agreed to the Dataset License. The fact table will have 8 columns - 5 dimensions and 3 measures. Can I get supermarket or retail dataset from net? I am working on association rule mining for retail dataset. The Machine Learning Toolkit contains datasets that were provided by others. The first step towards that is creating a index, like the one given below to determine the index from the 1 st to the nth row of the dataset: index<-1:nrow(dataset) 9. Time series can be represented using either plotly. If you would like to see what exists in the index, just try to console it out. Designing CSV files Leigh Dodds Open Data March 7, 2017 March 7, 2017 5 Minutes A couple of the projects I’m involved with at the moment are at a stage where there’s some thinking going on around how to best provide CSV files for users. Carriage Services, Inc. Backorders are products that are temporarily out of stock, but a customer is permitted to place an order against future inventory. Save as CSV tuncates large datasets Post by mike thomas » Mon Mar 24, 2014 4:56 pm When saving a capture containing more than 1M samples, the output is truncated to exactly 1M samples (1,048,576) when saving as CSV or text. These are techniques that fall under the general umbrella of association. - SamTube405/Amazon-E-commerce-Data-set. Search Datasets. Find CSV files with the latest data from Infoshare and our information releases. Flexible Data Ingestion. By seeing this R barplot or bar chart, One can understand, Which product is performing. csv; test_ver2. The head() function returns the first 5 entries of the dataset and if you want to increase the number of rows displayed, you can specify the desired number in the head() function as an argument for ex: sales. Generate a bar graph of 'Product line' & mean of the 'Revenue'. Browse the files from the computer and upload our Excel or CSV file to Azure Machine Learning storage. The new content is named after the sample and is marked with a yellow asterisk. With each sales quota change, the number of SalesPersonQuotaHistory rows will muliply. The Sales Jan 2009 file contains some "sanitized" sales transactions during the month of January. csv (40kB) , json (139kB) pharmaceutical-drug-spending_zip: Compressed versions of dataset. Publisher - Current Organization Name: Statistics Canada. In this Introduction to Web Scraping tutorial, we show you how to parse a web page into a data file (csv) using a Python package called BeautifulSoup. T = readtable( 'myfile. {"@context":"https:\/\/project-open-data. Carriage Services, Inc. Download the list of variables and countries in the dataset. A constituency-level breakdown of parties, candidates, votes and percentage swings in vote share. Lumira prompts you to add the linked dimension to the visualization. The number of keypoints on each image varies, with the max number of keypoints being 15 on a single image. Usage Note 23652: How can I create a CSV file with ODS? The ODS CSV and ODS CSVALL destinations can be used to generate files with comma separated values. Get information about the dataset using describe() & info(). Beyond this - you can import information into any custom taxonomies , so you can add or update all the data about your products. A Purchase Order is a document sent by the Council to a supplier indicating types, quantities, and agreed prices for products or services. They provide names, addresses, and contact information for suppliers that provide services or products under the Medicare program. The file must be unzipped before use. CSV (comma separated value) is well known file format to store tabular data. gov means it’s official. Download Open Datasets on 1000s of Projects + Share Projects on One Platform. Product_Category_2 and Product_Category_3: Have NaN values. CSV files? Do all. Since this corresponds to the total number of cells in the csv, I'm pretty sure it either has to do with the csv formatting (there are spaces in some of the header strings which I would like to keep if there is a way to do so) or that I did not use a necessary parameter. Walmart challenges participants to accurately predict the sales of 111 potentially weather-sensitive products (like umbrellas, bread, and milk) around the time of major weather events at 45 of their retail locations. SPSS file formats. Download Dataset. To import data from a CSV file into MATLAB use the “readtable” function. The data sets that follow are all in CSV format unless otherwise noted. Intake abstracts away messy data storage practices so data users don’t need to know about it. Replace data values. Follow the steps below to convert a simple CSV into a Parquet file using Drill: Prerequisites. You can use code to achieve this, as you can see in the ConvertUtils sample/test class. Use the CData ODBC Driver for CSV to create datasets from CSV data in Domo Workbench and then build visualizations in the Domo service. Predict the online sales of a consumer product based on a data set of product. The lm function really just needs a formula (Y~X) and then a data source. Calculations on Dataset Arrays. Discover what’s changed and get in touch to give us your feedback. To import data from a CSV file into MATLAB use the “readtable” function. The round function in R programming also allows you to round the numeric values in a database, or table columns. So that company can target only those customers who belong to that age group. gov has grown to over 200,000 datasets from hundreds of … Continued. Balance of payments (BOP) statistics for OECD member and non-member countries according to BPM6 classification are included in this dataset. An example of regression would be predicting how many sales a store may make next month, or what the future price of your house might be. Tables, charts, maps free to download, export and share. CSVs look like a garden-variety spreadsheet but with a. import pandas as pd Now let's read dataset and see it. graph_objects charts objects (go. Flexible Data Ingestion. They differ from other. THANK YOU # This is the server logic of a Shiny web application. We create a Table Box using the menu Layout → New Sheet Objects → Table Box where we choose all the three fields - ProductID, ProductCategory and SaleAmount to be displayed. 1) FRESH: annual spending (m. Explore Popular Topics Like Government, Sports, Medicine, Fintech, Food, More. Change variable name. Stanford CS341 only datasets. csv, then click Add Files (s) and OK button to open Comma Delimited (CSV): impCSV dialog. Licensing: The computer code and data files described and made available on this web page are distributed under the GNU LGPL license. These are the official datasets used on the Medicare. You can export all orders or customers using the bulk export tool under WooCommerce > CSV Export > Export. 13 million reviews). We collect information from people and organisations through censuses and surveys, and use it to provide insights and data about New Zealand. SPSS file formats. We are Ordnance Survey Licensed Partners and also resellers of map datasets from around the world. loadtxt('sales. These 998 transactions are easily summarized and filtered by transaction date, payment type, country, city, and geography. Here you can find symbols and pictograms for all transport modes to use in your apps, products and other projects. How to Open CSV Files. These are not real sales data and should not be used for any other purpose other than testing. Data and Resources. The dataset contains a large number of records (over 140000 sales records in a given week for each store in the training dataset), and it is incomplete (not all fields of all records are completed). Book-Crossing Dataset mined by Cai-Nicolas Ziegler, DBIS Freiburg Collected by Cai-Nicolas Ziegler in a 4-week crawl (August / September 2004) from the Book-Crossing community with kind permission from Ron Hornbaker, CTO of Humankind Systems. If you use this data set, please acknowledge the funding support and operational support for STAR. A look at the big data/machine learning concept of Naive Bayes, and how data sicentists can implement it for predictive analyses using the Python language. Building Your First Machine Learning Model Using KNIME have collected 2013 sales data for 1559 products across 10 stores in different cities. Related Data and Programs: CENSUS, a dataset directory which contains US census data;. Listing of all data products and interactive maps on the ERS website. Please note column names are case sensitive and should be lower case to match exactly. The round function in R programming also allows you to round the numeric values in a database, or table columns. There are many ways to see the similarities between items. Second – and not surprisingly – now you have a chance to collect data the right way. The classicmodels database is a retailer of scale models of classic cars database. 7 million vehicle car parts of 68 makes from year 1942 to 2015, in 12 highly structural data tables, and a package of 1,702,044 JPEG part image files of a total download size of 30. General Services Administration (GSA) in May 2009 with a modest 47 datasets, Data. We can write the data set to a. Description: Product (item) name. Have each export to their own file, combine the files at the end. 5 7-Jan,236. 0 Content-Type: multipart/related. Download the dataset. In this tutorial, we will see how to plot beautiful graphs using csv data, and Pandas. I would like to apply one or more data mining techniques to a dataset, in order to see the effect advertising has on sales. Ideally we are going to subset a larget dataset. To fix it, open the file in a text editor. Buy Online keeping the car safe transaction. Accelo’s Built-In Reports. If you are wanting to import data from a third-party such as a distributor or another ecommerce platform, we recommend taking the time to match your third-party CSV’s column headings with the attributes available in BigCommerce. Using the pandas read_csv method we loaded the data format file into pandas dataframe. This page contains a list of datasets that were selected for the projects for Data Mining and Exploration. Your Sales Director has just asked you to generate additional revenues of $1,500,000 before September 01, 2007. By seeing this R barplot or bar chart, One can understand, Which product is performing. Follow the steps below to convert a simple CSV into a Parquet file using Drill: Prerequisites. The Dataset show() action displays the top 20 rows in a tabular form. We would love to find out more about how Open Data from data. csv with the pandas function: read_csv(). Others come from the Data and Story Library. 5 12-Jan,190. Spark’s primary data abstraction is an immutable distributed collection of items called a resilient distributed dataset (RDD). LegiScan current and historical legislative archives available for download in JSON, XML, or CSV formats for Delaware. Others come from various R packages. In the neural network toolbox in matlab (nnstart), i am using the Pattern recognition tool (nprtool); and i want to import a dataset from an excel file to the target field in the toolbox. Create a dataset array using default settings. $\begingroup$ Does it mean that at every product code i read in loop , i check for the date difference ,if the date difference is huge say more than 1 month , i start zero filling from then and adjust the Sales data reading from original dataset , please correct me if iam wrong , would be great if it can be explained further with sample dataset. Microsoft Excel 2007 Microsoft Excel 2003 Tab separated values (TSV) Comma separated values (CSV). These are not real sales data and should not be used for any other purpose other than testing. In this linear regression example, the label is the 2015 median sales price and the feature is the 2014 population estimate. load is generally best used with either MAT files, or files saved from MATLAB using save, maybe with the -ascii or similar option. json", "@type": "dcat:Catalog", "conformsTo": "https. As a by-product of this research cooperation, approximately nine years of store-level data on the sales of more than 3,500 UPCs is available in this dataset. Refined petroleum products statistics, monthly Data presented at the national level by refined petroleum product (motor gasoline, heavy fuel oil, diesel fuel oil, etc) and disposition (production of saleable products, net sales and closing inventory). Below is the list of csv files the dataset has along with what they include:. Below is a sample of a report built in just a couple of minutes using the Blank Canvas app. Execute SQL to remote CSV data in Jaspersoft Studio. 5 billion clicks dataset available for benchmarking and testing Over 5,000,000 financial, economic and social datasets New pattern to predict stock prices, multiplies return by factor 5 (stock market data, S&P 500; see also section in separate chapter, in our book). Follow the steps below to convert a simple CSV into a Parquet file using Drill: Prerequisites. It includes the annual spending in monetary units (m. Use the CData ODBC Driver for CSV to create datasets from CSV data in Domo Workbench and then build visualizations in the Domo service. Data set presents historical energy use in native units and billion site-delivered Btu and costs (in 2012 dollars) aggregated at the top-tier Federal agency level for the fiscal. Year dimension. Computer Security. apache-flink documentation: Join tables example. Monthly data sales by product group for 2012-2013 API CSV. read the rows from the CSV-File - perhaps you iterate until you reach the EndOfFile 3. Companies with reportable ingredients in their products must submit information to the California Safe Cosmetics Program if the company: Has annual aggregate sales of cosmetic products of one million dollars or more, and; Has sold cosmetic products in California on or after January 1, 2007. Students can choose one of these datasets to work on, or can propose data of their own choice. Many a times the dataset we are dealing with can be too large to be handled in python. But randomly generated data is awful — it doesn't have realistic distributions, and it isn't easy to understand whether your results are meaningful and correct. Includes normalized CSV and JSON data with original data and datapackage. So the idea is to find out the properties of a product, and store which impacts the sales of a product. uk to help you find and use open government data. GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together. sourced from CSV load you need to Include the new field on your CSV sourced from Salesforce then on the Dataflow you have to add the new column sourced from an external dataset, Integration System Pushing the data to wave should add the new column. Business and Finance` retail` finance` sales` store` Code for querying and downloading Flickr images. The lm function really just needs a formula (Y~X) and then a data source. The new content is named after the sample and is marked with a yellow asterisk. 5 years of customers behavior data from Santander bank to predict what new products customers will purchase. Learn More. Spreadsheet. The datasets are older, but still good. The companies that started data collection with paper ledgers and ended with. New motor vehicle sales Number of units and total sales of new motor vehicles by vehicle type and origin of manufacture, monthly. You can include any field for an object that you're processing. CSV files are commonly used to transfer data from one database or spreadsheet format to another. Annual BC Liquor Sales by Region and Product Type - FYE 2010 - FYE2012 Annual sales to BC Liquor Store counter customers for 3 fiscal years (2009/10, 2010/11, 2011/12) by product category (beer, refreshment category, spirits, wine) and by BC. Once this command is executed by pressing Enter, the dataset will be downloaded from the internet, read as a csv file and assigned to the variable name acs. ALL Online Courses 75% off for the ENTIRE Month of October - Use Code LEARN75. ‘Farmers Markets’ are considered a temporary use and as such, they are defined in Section 11. Home; Product sales report (IBIS) stores. If you have any questions regarding the challenge, feel free to contact [email protected] Discover what's changed and get in touch to give us your feedback. In addition to peoples. Get the summary of the dataset. Methodologies for Converting Microsoft Excel®. View this Dataset The Consumer Complaint Database contains data from the complaints received by the Consumer Financial Protection Bureau ( CFPB ) on financial products and services, including bank accounts, credit cards, credit reporting, debt collection, money transfers, mortgages, student loans, and other types of consumer credit.