Step 1: Import all necessary packages, convert the excel file into a csv file then use pandas to open the file.
Checking the number of records(rows) and fields(columns)
Checking for null values
Handling null values by dropping empty columns
Questions to be answered during analysis
1. What feature is mostly used by users in (categorized by location, gender and age group)? 2. What feature do users think is the most effective/ineffective and why (categorized by location, gender and age group)?? 3. What percentage of users think the platform is easy to use, has convenient banking, secure to use, consistent across digital platforms, reliable and convenient, by gender and age group?5. what location do they have the highest users 6. what percentage of customers will recommend the platform 7. what new features or services will users want by gender and age group
Renaming columns and encoding ( relabeling) values for better identification for analysis
Index(['ID', 'Q1', 'Q2', 'Q2a', 'Q3', 'Q3a', 'Q4a', 'Q4b', 'Q4c', 'Q4d', 'Q4e', 'Q5', 'Q6', 'Age_Group', 'Location', 'Gender', 'Unnamed: 16', 'Unnamed: 17', 'Unnamed: 18', 'Unnamed: 19', 'Unnamed: 20', 'Unnamed: 21', 'Unnamed: 22', 'Unnamed: 23'], dtype='object')
Analysis and insights
Top 3 locations of SkyeXperience users are Lagos accounting for 28% (189 users), Abuja accounting for 8% (58 users) and Ibadan accounting for 4% (41 users)of total users across locations.
71% of SkyeXperience users are male(471 users) and 28% are Female(186 users)
Q1- What features do users mostly use.
['a. To transfer money'] ['c. To purchase airtime'] ['a. To transfer money', ' c. To purchase airtime']
The most used feature on the platform is the Transfer money feature followed by the Purchase airtime feature and lastly a combination of both transfer money and purchase airtime
Q2. What features do users think are most effective and ineffective
['a. To transfer money'] ['a. To transfer money', ' c. To purchase airtime'] ['a. To transfer money', ' d. To pay bills']
Users say the transfer money feature is the most effective and their top 3 reasons are to transfer money, to purchase airtime and to pay bills
Q3. -What features are ineffective and reasons
['c. To purchase airtime'] ['reason:It more easier' 'reason:It more easier'] ['c. To purchase airtime'] ['reason:experience' 'reason:experience'] ['a. To transfer money'] ['reason:I do transfer regularly' 'reason:I do transfer regularly']
Q4- What percentage of users think the platform is easy to use, has convenient banking, secure to use , consistent across digital platforms and reliable
97% of users agree that the platform is easy to use as they make use of the transfer money feature the most.
92% of users agree that the platform has convenient banking system in place
81% of users say that the platform is secure to use and 17% of users are indifferent about the security of the platform
Majority of users 92% agree that the platform is consistent across digital platforms
Majority of users 93% agree that the platform is reliable.
Q5. Likelihood of users to recommend the platform to others
Majority of users (79%) would likely recommend the platform to others whereas 16% of users are of the opinion that they're unlikely to recommend.