AI Script for Excel Data Analysis
Document Details
Tags
Summary
This document describes a dataset stored in an Excel file and asks for R and SQL scripts to analyze the data. It seeks to find popular books and profiles looking for friendship, using the 'FavoriteBooks' and 'Profiles' table columns, and needs help with the Excel calculations and SQL queries.
Full Transcript
Here is a description of a dataset I am working with: Table: Profiles Columns: ProfileID, Name, MemberSince, LastUpdate, Status, Sex, State Table: FavoriteBooks Columns: ProfileID, FavoriteBook Table: RelationshipStatus Columns: ProfileID, RelationshipStatus Table: LookingFor Columns: Profil...
Here is a description of a dataset I am working with: Table: Profiles Columns: ProfileID, Name, MemberSince, LastUpdate, Status, Sex, State Table: FavoriteBooks Columns: ProfileID, FavoriteBook Table: RelationshipStatus Columns: ProfileID, RelationshipStatus Table: LookingFor Columns: ProfileID, LookingFor Table: interests Columns: ProfileID, Interests The data is stored as an Excel file. I would like an R script that reads the file in, and then calculates the ten most popular books according to the FavoriteBooks table. Please write code to return the count of profiles looking for friendship by different Sex values. Write a query to return the most popular books among profiles who also list "Harry Potter" anywhere within an entry for favorite book. Can you translate the code into SQL? I would like to write code inside of the Excel workbook file to make these calculations \-- can you help?
