Untitled
[{'section_data': '[\n {\n "widget_title": "Location same as reported to RBI and published on website",\n "widget_description": "Display Donut Chart using Compliance: Check whether branch is located on same premise as reported to RBI and published on ABFL website? (Y/N)",\n "graph_data": {\n "Joshua Lalropui Sinate": 23,\n "R Raja": 22,\n "Abhijit Omprakash Chinchkhede": 16,\n "Komalben Rohitkumar Ardeshana": 16,\n "Shivangi Tomar": 13,\n "Md Aftab Alam": 13,\n "Akhilesh Gurjar": 12,\n "Madhuri Haresh Shyamdasani": 11,\n "Fathima Kubra Khanum": 10,\n "Raghu Sai Lakshmana Venkata Subba Rao Pulavarthy": 10,\n "Lakshay Sukhija": 9,\n "Rajvardhan Dubey": 9,\n "Praneet Prakash Basannavar": 9,\n "Satvik Sushil": 9,\n "Jyoti Nipun Mahajan": 8,\n "Aparna Passi": 7,\n "Meena Prakash Chaurasia": 7,\n "Shreya Singh": 7,\n "Koustav Chakraborty": 7,\n "Priyanka Joshi Sidhaye": 7,\n "Prachi Rathi": 7,\n "Vinit Bhandari": 7,\n "Darshan Uday Samant": 6,\n "Abhijit Ramkrishna Adkar": 5,\n "Nikhil Jagtap": 5,\n "Santosh Kumar Singh": 5,\n "Yogita Sarup Sharma": 5,\n "Shamli Chandrakant Akolkar": 4,\n "Harneet Kaur": 4,\n "Sakshi Jha": 3,\n "Aditi Dave": 3,\n "Neha Krishna Gatla": 3,\n "Pundrikaksh Ghodke": 3,\n "Vipin Vishal Choudhary": 3,\n "Ankush Madanrao Bahirat": 2,\n "Priya Gupta": 2,\n "SUPRIYA STANI D\'SOUZA": 2,\n "Chirag uday Desai": 2,\n "Employee Name": 1,\n "Tanvi Gupta": 1,\n "Vaishali Mahesh Abitkar": 1\n }\n },\n {\n "widget_title": "Regulatory notices and licenses display on notice",\n "widget_description": "Display Donut Chart using Compliance: Check whether all regulatory notices and licenses are displayed on notice board? (Y/N)",\n "graph_data": {\n "HR Business Partner": 92,\n "Management Trainee": 73,\n "Senior HR Business partner": 29,\n "Business Partner HR": 22,\n "Regional HR Manager": 19,\n "Team Member - ER & Compliance": 10,\n "Human Resources Business Partner": 9,\n "Team Lead - Talent Management": 9,\n "Lead - Behavioural L&D and HRBP": 7,\n "Lead - L&D": 7,\n "Lead - Content and Technology": 5,\n "Head - Functional Training": 5,\n "Zonal HR Business Partner": 4,\n "Team Lead - Talent Acquisition": 2,\n "Regional Training Manager": 2,\n "Team Member Talent Acquisition": 2,\n "Designation": 1,\n "Lead - HR Business Partner": 1\n }\n }\n]', 'sectionTitle': 'Branch Excellence Analysis', 'gridDashBoard': [{'x': 0, 'y': 0, 'cols': 9, 'rows': 6, 'title': 'Branch Excellence Score', 'description': 'Create a bar graph to represent the Branch Excellence Scores, categorized as follows:\n1.\tBranches with a score ≤ 3.0\n2.\tBranches with a score > 3.0 and ≤ 3.5\n3.\tBranches with a score > 3.5 and ≤ 4.0\n4.\tBranches with a score > 4.0 and ≤ 4.5\n5.\tBranches with a score > 4.5 and < 5.0\n6.\tBranches with a score of 5.0\nEach category should be represented on the x-axis, while the count of branches in each category should be plotted on the y-axis for comparison.\n'}, {'x': 9, 'y': 0, 'cols': 9, 'rows': 6, 'title': 'State wise Excellence Score', 'description': 'Generate a bar graph showing state-wise excellence scores, with all the states on the x-axis and their corresponding average Branch Excellence scores on the y-axis.'}, {'x': 0, 'y': 6, 'cols': 9, 'rows': 5, 'title': 'Zone Wise Excellence Score', 'description': 'Create a bar graph displaying zone-wise excellence scores. The data includes a list of zones: North, South, East, West and their corresponding Branch Excellence score. Represent each zone as a distinct category on the x-axis and their excellence scores on the y-axis to visualize performance comparisons.'}, {'x': 9, 'y': 6, 'cols': 9, 'rows': 5, 'title': 'Area wise Excellence Score', 'description': 'Create a bar graph displaying area/function-wise excellence scores based on ratings for Branding, System/Digital, Compliance, Training, Administrative, Staff Details, Support Staff, Customer Service, Loan Processing, and Business Targets, with areas/functions on the x-axis and their aggregated scores on the y-axis.'}]}, {'section_data': "It seems there was an issue with the execution of the Python code due to missing or incorrectly referenced column names in the dataset. Specifically, the column `'Branch Excellence Score'` and other required columns like `'State'`, `'Zone'`, and `'Area'` were not found in the dataset.\n\nTo resolve this, I need clarification on the exact column names in the dataset that correspond to the following:\n1. Branch Excellence Score\n2. State\n3. Zone\n4. Area\n5. Scores for categories like Branding, System/Digital, Compliance, etc.\n\nPlease provide the correct column names or confirm if the dataset has these fields under different names.", 'sectionTitle': 'Branding', 'gridDashBoard': [{'x': 0, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'Hoarding Board Visibility', 'description': 'Display Donut chart using Branding: Is the hoarding board clearly visible outside branch premise? (Y/N) with Yes and No'}, {'x': 9, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'Information visibility and display outside Branch', 'description': 'Display Donut chart using Branding: Check whether all relevant information is visible and displayed outside branch premise? (Y/N) with Yes and No'}]}, {'section_data': 'It seems that the column names provided in the instructions do not match the actual column names in the dataset, or there was an issue with the code execution. Could you confirm the exact column names related to "Hoarding Board Visibility" and "Information visibility and display outside Branch"? Alternatively, I can inspect the dataset\'s structure to identify the correct columns. Let me know how you\'d like to proceed.', 'sectionTitle': 'Administrative', 'gridDashBoard': [{'x': 0, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'Visitors’ register for walk-ins', 'description': "Display Donut chart using Administrative: Is the visitors' register maintained for all walk-ins to the branch? (Y/N) with Yes and No"}, {'x': 9, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'Security Personnel presence', 'description': "Display Donut Chart using Administrative: Is the visitors' register maintained for all walk-ins to the branch? (Y/N) with Yes and No"}, {'x': 0, 'y': 4, 'cols': 9, 'rows': 4, 'title': 'CCTV Installation', 'description': 'Display Donut Chart using Administrative: Check whether CCTV is installed and working in branch premises? (Y/N) with Yes and No'}, {'x': 9, 'y': 4, 'cols': 9, 'rows': 4, 'title': 'CCTV Monitoring and Footage Maintenance', 'description': 'Display Donut Chart using Administrative: Check whether CCTV is being monitored regularly and footage is saved/maintaned? (Y/N) with Yes and No'}, {'x': 0, 'y': 8, 'cols': 9, 'rows': 4, 'title': 'Basic Branch Infrastructure', 'description': 'Display Donut Chart using Administrative: Is basic branch infrastructure (fan, desks, chairs, etc) provided adequately and in proper condition? (Y/N) with Yes and No'}, {'x': 9, 'y': 8, 'cols': 9, 'rows': 4, 'title': 'Original Agreements', 'description': 'Display Donut Chart using Administrative: Are there any original agreements present at branch (vendor agreement, rent agreement)? (Y/N) with Yes and No'}, {'x': 0, 'y': 12, 'cols': 9, 'rows': 4, 'title': 'Branch Hygiene', 'description': 'Display Donut Chart using Administrative: Is branch hygiene properly maintained? (Y/N) with Yes and No'}]}, {'section_data': 'It seems there is an issue with loading or processing the data from the provided file. The problem might be related to the structure or content of the Excel file. To resolve this, I recommend verifying the file structure, ensuring that it contains valid data, and confirming that all required columns are correctly labeled or identifiable. If you can provide more details about the file or its structure, I can assist further.', 'sectionTitle': 'Support Staff Details', 'gridDashBoard': [{'x': 0, 'y': 0, 'cols': 9, 'rows': 5, 'title': 'Staff Distribution across branches', 'description': 'Create a stacked bar chart to visualize the staff distribution across branches. Use the following data points:\n•\tX-Axis: Branch names \n•\tY-Axis: Number of employees.\n•\tCategories to stack:\no\tFull-Time Employees\no\tOff-Roll Employees\no\tSupport Staff in Housekeeping and Security\n'}, {'x': 9, 'y': 0, 'cols': 9, 'rows': 5, 'title': 'Support Staff empanelment with registered vendor', 'description': 'Display Donut Chart using Support Staff: Check whether the support staff is empanelled with registered vendor? (Y/N) with Yes and No'}, {'x': 0, 'y': 5, 'cols': 9, 'rows': 4, 'title': 'Attendance Register for contract employees', 'description': 'Display Donut Chart using Support Staff: Whether branch maintains monthly attendance register for contract employees (Y/N) with Yes and No'}]}, {'section_data': '```json\n[\n {\n "widget_title": "Staff Distribution across branches",\n "widget_description": "Create a stacked bar chart to visualize the staff distribution across branches.",\n "graph_data": {\n "Branch Name": ["Abohar", "Agra", "Ahmedabad", "Ahmedabad- Ratnaakar Nine Square", "Ajmer", "Ajwa Road", "Akola", "Amravati-2", "Amritsar", "Amroli", "Anand", "Anugul ", "Arakonam", "Arani", "Arrah", "Asansol", "Aurangabad-2", "Aurangabad-3", "Balasore", "Bangalore - Star Avenue", "Baroda", "Bassi", "Bayad", "Beawar", "Beed", "Behrampore", "Belapur", "Belgaum", "Bhadrak", "Bharuch", "Bhilwara", "Bhiwadi", "Bhiwani", "Bhubaneshwar", "Bhubaneshwar - Chandrasekarpur", "Bijaynagar", "Burdwan", "Calicut", "Chandigarh - Sector 8C", "Chandigarh- Sector 9D", "Chandrapur", "Chennai", "Chhatarpur", "Chhindwara", "Chittorgarh", "Coimbatore", "Cuttack", "Darbhanga", "Dausa", "Davangere-1", "Davangere-2", "Dehradun", "Delhi- Nehru Place", "Deoli", "Dewas", "Dhule", "Dindigul", "Dudu", "Durgapur", "Eluru", "Erode", "Fatehabad", "Gondia", "Guntur", "Gurgaon-1", "Gurgaon-2", "Haridwar", "Hassan", "Hinganghat", "Hoshiarpur", "Hosur", "Hubli-1", "Hubli-2", "Hyderabad", "Hyderabad - Somajiguda", "Ichalkaranji", "Idappadi", "Itarsi", "Jagatsinghpur", "Jaipur-2", "Jalandhar", "Jalgaon-1", "Jalna", "Jamshedpur", "Jamshedpur- Bistupur Main Road", "Jobner", "Kaithal", "Kalol", "Kalyan", "Kanchipuram", "Kannur", "Kanpur", "Karad", "Karimnagar", "Kekri", "Khorda- Uparsahi", "Kishangarh", "Kolhapur", "Kolkata- Bangur Estate", "Kollam", "Kota", "Krishnagiri", "Kurukshetra", "Lucknow", "Madurai - Palanganatham-3", "Madurai-1", "Madurai-4", "Madurai-Thallakulam-2", "Mahbubnagar", "Mahendragarh", "Mandya", "Mangalore", "Medak", "Meerut", "Moradabad", "Mumbai - Andheri", "Mumbai - Borivali", "Mysore", "Nadiad", "Nagda", "Nagercoil", "Nagpur", "Nalgonda", "Nanded-2", "Narol Branch", "Nashik-Mumbai Naka", "Nasik", "New Delhi - Janakpuri", "New Delhi - Rajendra Place", "New Delhi-Vijaya Building", "Neyveli", "Nizampura", "Noida", "Omalur", "Panipat", "Panruti", "Panvel", "Pollachi", "Pondicherry-1", "Pondicherry-2", "Pudukkottai", "Puri", "Puri- Vip Road", "Rajkot - Imperial Heights", "Ranchi-1", "Ranchi-2", "Ranebennur", "Ratlam", "Rayagada", "Rohtak", "Roorkee", "Sagar", "Salem", "Sambalpur - Budharaja", "Sangli-2", "Sangrur", "Satara", "Satna", "Secunderabad", "Sirsa", "Sivakasi", "Solan", "Sonipat", "Sundargarh", "Surat - Rockford", "Surat- Milestone", "TUTICORIN", "Tenkasi", "Thane - Khopat", "Thanjavur", "Theni", "Tiruchirappalli-Thillai Nagar", "Tirunelveli", "Tiruvallur", "Tiruvannamalai", "Trichy", "Trichy - Thiruverumbur", "Trivandrum", "Tumkur", "Usilampati", "Vellore", "Vijayawada", "Villupuram", "Virar", "Visakhapatnam", "Vizianagaram", "Warangal", "Wardha", "Yavatmal", "Zirakpur"],\n "Full-Time Employees": [3, 80, 20, 74, 19, 5, 2, 11, 22, 7, 2, 9, 6, 6, 6, 4, 8, 20, 9, 178, 66, 14, 3, 5, 2, 10, 25, 7, 9, 4, 4, 6, 8, 60, 20, 14, 10, 7, 175, 72, 4, 8, 3, 2, 6, 72, 42, 7, 6, 2, 3, 41, 90, 6, 5, 3, 8, 8, 10, 2, 17, 4, 1, 12, 90, 3, 15, 5, 4, 1, 9, 3, 7, 58, 86, 9, 7, 6, 15, 24, 14, 4, 4, 6, 5, 16, 7, 5, 8, 17, 1, 46, 4, 8, 6, 9, 5, 43, 55, 6, 31, 2, 10, 49, 53, 74, 51, 53, 4, 3, 2, 12, 1, 6, 17, 13, 8, 12, 7, 8, 20, 18, 1, 6, 5, 5, 28, 12, 4, 723, 2, 13, 261, 8, 38, 2, 9, 10, 20, 24, 1, 18, 8, 30, 51, 45, 3, 4, 7, 18, 3, 4, 44, 12, 6, 3, 8, 4, 203, 12, 6, 6, 10, 7, 22, 30, 17, 5, 15, 8, 7, 8, 21, 7, 20, 13, 5, 2, 5, 7, 12, 31, 17, 3, 56, 4, 11, 3, 1, 20],\n "Off-Roll Employees": [0, 14, 0, 7, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 5, 1, 1, 0, 0, 7, 20, 0, 0, 0, 2, 0, 0, 4, 0, 0, 0, 0, 0, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 6, 0, 3, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 2, 1, 6, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 4, 0, 80, 0, 1, 16, 0, 9, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 0, 0, 5, 0, 1, 0, 4, 2, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0],\n "Support Staff": [1, 7, 3, 5, 1, 3, 1, 1, 6, 2, 1, 1, 1, 1, 1, 5, 1, 2, 1, 8, 5, 3, 1, 1, 1, 1, 1, 3, 1, 1, 2, 1, 4, 6, 1, 3, 2, 3, 8, 8, 2, 2, 3, 3, 2, 6, 4, 1, 2, 2, 1, 5, 13, 1, 3, 2, 1, 2, 7, 1, 1, 1, 1, 2, 11, 3, 7, 1, 1, 2, 1, 2, 1, 6, 5, 2, 0, 6, 2, 3, 4, 3, 1, 1, 1, 2, 2, 1, 1, 3, 2, 8, 2, 1, 1, 1, 1, 3, 5, 1, 5, 1, 2, 3, 6, 12, 10, 6, 1, 1, 1, 3, 1, 2, 1, 1, 2, 2, 1, 6, 3, 2, 1, 1, 1, 1, 5, 7, 3, 17, 1, 2, 24, 1, 5, 1, 1, 1, 4, 2, 1, 3, 1, 2, 7, 3, 1, 5, 1, 5, 2, 3, 3, 2, 1, 1, 1, 3, 54, 6, 0, 1, 4, 1, 2, 2, 8, 0, 4, 3, 1, 0, 5, 3, 5, 3, 0, 3, 2, 1, 3, 2, 2, 2, 8, 1, 2, 1, 1, 8]\n }\n },\n {\n "widget_title": "Support Staff empanelment with registered vendor",\n "widget_description": "Display Donut Chart using Support Staff: Check whether the support staff is empanelled with registered vendor? (Y/N)",\n "graph_data": {\n "Yes": 288,\n "No": 10\n }\n },\n {\n "widget_title": "Attendance Register for contract employees",\n "widget_description": "Display Donut Chart using Support Staff: Whether branch maintains monthly attendance register for contract employees (Y/N)",\n "graph_data": {\n "Yes": 259,\n "No": 39\n }\n }\n]\n```', 'sectionTitle': 'IT / Digital', 'gridDashBoard': [{'x': 0, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'Hardware/Software or Connectivity Issues Faced by Branch', 'description': 'Display Donut Chart using System/Digital: Any hardware/software or connectivity issues faced by the branch? (Y/N) with Yes and No'}, {'x': 9, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'Application Performance Status', 'description': 'Display Donut Chart using System/Digital: Are the applications working fine? (Y/N) with Yes and No'}]}, {'section_data': '```json\n[]\n```', 'sectionTitle': 'Customer Service', 'gridDashBoard': [{'x': 0, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'Complaint Register and Resolution Status', 'description': 'Display Donut Chart using Customer Service: Check whether any complaint register maintained at branch and all resolutions are captured? (Y/N) with Yes and No'}]}, {'section_data': 'The dataset appears to have unnamed columns, which makes it challenging to identify the relevant column for "Complaint Register and Resolution Status." If you have specific information about the column\'s position or name, please provide it so I can proceed accurately. Alternatively, I can analyze the dataset further to infer the correct column. Let me know how you\'d like to proceed.', 'sectionTitle': 'Loan Processing', 'gridDashBoard': [{'x': 0, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'TAT for Loan Document processing', 'description': 'Create a Bar graph showing:\nX-axis: Branch Name \nY-axis: Average of Loan Processing: Check TAT for storage and retrieval for customer and loan documents\n'}, {'x': 9, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'Loan Processing tracker/MIS status for Central Team', 'description': 'Display Donut Chart using Loan Processing: Check whether any tracker / MIS maintained for loan processing and shared with central team (if any)? (Y/N) with Yes and No'}]}, {'section_data': 'The column names in the provided dataset are currently unnamed (e.g., "Unnamed: 0", "Unnamed: 1", etc.). To proceed with the analysis, I need to know the actual column names or their corresponding indices that represent the following:\n\n1. **Branch Name**.\n2. **Loan Processing: Check TAT for storage and retrieval for customer and loan documents**.\n3. **Loan Processing: Check whether any tracker/MIS maintained for loan processing and shared with the central team (if any)? (Y/N)**.\n\nCould you provide the correct column names or indices for these fields?', 'sectionTitle': 'Business Targets', 'gridDashBoard': [{'x': 0, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'FLS achievement of Business Targets Historical', 'description': 'Display Donut Chart using Business Targets: Check whether the FLS are achieving the business targets historically? (Y/N) with Yes and No'}]}, {'section_data': '{"widget_title": "FLS achievement of Business Targets Historical", "widget_description": "Display Donut Chart using Business Targets: Check whether the FLS are achieving the business targets historically? (Y/N) with Yes and No.", "graph_data": {"labels": [], "values": []}}', 'sectionTitle': 'Training', 'gridDashBoard': [{'x': 0, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'Regular Training Sessions for Branch Employees', 'description': 'Display Donut Chart using Training: Whether regular training sessions being conducted for the branch employees? (Y/N) with Yes and No'}]}, {'section_data': '{"widget_title": "Regular Training Sessions for Branch Employees", "widget_description": "Display Donut Chart using Training: Whether regular training sessions being conducted for the branch employees? (Y/N) with Yes and No.", "graph_data": {"Yes": 0, "No": 0}}', 'sectionTitle': 'Employee Board', 'gridDashBoard': [{'x': 0, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'Employee Board', 'description': 'Show in Tabular form with columns as : Employee Name, Number of Survey taken and Average score given'}]}, {'section_data': '```json\n{\n "widget_title": "Employee Board",\n "widget_description": "Show in Tabular form with columns as : Employee Name, Number of Survey taken and Average score given.",\n "graph_data": [\n {\n "Employee Name": "Abhijit Omprakash Chinchkhede",\n "Number of Survey Taken": 16,\n "Average Score Given": 4.8125\n },\n {\n "Employee Name": "Abhijit Ramkrishna Adkar",\n "Number of Survey Taken": 5,\n "Average Score Given": 3.8\n },\n {\n "Employee Name": "Aditi Dave",\n "Number of Survey Taken": 3,\n "Average Score Given": 5.0\n },\n {\n "Employee Name": "Akhilesh Gurjar",\n "Number of Survey Taken": 12,\n "Average Score Given": 3.9166666666666665\n },\n {\n "Employee Name": "Ankush Madanrao Bahirat",\n "Number of Survey Taken": 2,\n "Average Score Given": 5.0\n },\n {\n "Employee Name": "Aparna Passi",\n "Number of Survey Taken": 7,\n "Average Score Given": 3.7142857142857144\n },\n {\n "Employee Name": "Chirag uday Desai",\n "Number of Survey Taken": 2,\n "Average Score Given": 4.0\n },\n {\n "Employee Name": "Darshan Uday Samant",\n "Number of Survey Taken": 6,\n "Average Score Given": 4.666666666666667\n },\n {\n "Employee Name": "Fathima Kubra Khanum",\n "Number of Survey Taken": 10,\n "Average Score Given": 5.0\n },\n {\n "Employee Name": "Harneet Kaur",\n "Number of Survey Taken": 4,\n "Average Score Given": 5.0\n },\n {\n "Employee Name": "Joshua Lalropui Sinate",\n "Number of Survey Taken": 23,\n "Average Score Given": 4.521739130434782\n },\n {\n "Employee Name": "Jyoti Nipun Mahajan",\n "Number of Survey Taken": 8,\n "Average Score Given": 5.0\n },\n {\n "Employee Name": "Komalben Rohitkumar Ardeshana",\n "Number of Survey Taken": 16,\n "Average Score Given": 4.75\n },\n {\n "Employee Name": "Koustav Chakraborty",\n "Number of Survey Taken": 7,\n "Average Score Given": 4.142857142857143\n },\n {\n "Employee Name": "Lakshay Sukhija",\n "Number of Survey Taken": 9,\n "Average Score Given": 4.666666666666667\n },\n {\n "Employee Name": "Madhuri Haresh Shyamdasani",\n "Number of Survey Taken": 11,\n "Average Score Given": 4.363636363636363\n },\n {\n "Employee Name": "Md Aftab Alam",\n "Number of Survey Taken": 13,\n "Average Score Given": 4.615384615384615\n },\n {\n "Employee Name": "Meena Prakash Chaurasia",\n "Number of Survey Taken": 7,\n "Average Score Given": 3.857142857142857\n },\n {\n "Employee Name": "Neha Krishna Gatla",\n "Number of Survey Taken": 3,\n "Average Score Given": 4.0\n },\n {\n "Employee Name": "Nikhil Jagtap",\n "Number of Survey Taken": 5,\n "Average Score Given": 4.2\n },\n {\n "Employee Name": "Prachi Rathi",\n "Number of Survey Taken": 7,\n "Average Score Given": 4.142857142857143\n },\n {\n "Employee Name": "Praneet Prakash Basannavar",\n "Number of Survey Taken": 9,\n "Average Score Given": 3.888888888888889\n },\n {\n "Employee Name": "Priya Gupta",\n "Number of Survey Taken": 2,\n "Average Score Given": 4.5\n },\n {\n "Employee Name": "Priyanka Joshi Sidhaye",\n "Number of Survey Taken": 7,\n "Average Score Given": 5.0\n },\n {\n "Employee Name": "Pundrikaksh Ghodke",\n "Number of Survey Taken": 3,\n "Average Score Given": 3.3333333333333335\n },\n {\n "Employee Name": "R Raja",\n "Number of Survey Taken": 22,\n "Average Score Given": 4.7272727272727275\n },\n {\n "Employee Name": "Raghu Sai Lakshmana Venkata Subba Rao Pulavarthy",\n "Number of Survey Taken": 10,\n "Average Score Given": 4.3\n },\n {\n "Employee Name": "Rajvardhan Dubey",\n "Number of Survey Taken": 9,\n "Average Score Given": 3.3333333333333335\n },\n {\n "Employee Name": "SUPRIYA STANI D\'SOUZA",\n "Number of Survey Taken": 2,\n "Average Score Given": 3.5\n },\n {\n "Employee Name": "Sakshi Jha",\n "Number of Survey Taken": 3,\n "Average Score Given": 3.6666666666666665\n },\n {\n "Employee Name": "Santosh Kumar Singh",\n "Number of Survey Taken": 5,\n "Average Score Given": 4.0\n },\n {\n "Employee Name": "Satvik Sushil",\n "Number of Survey Taken": 9,\n "Average Score Given": 2.3333333333333335\n },\n {\n "Employee Name": "Shamli Chandrakant Akolkar",\n "Number of Survey Taken": 4,\n "Average Score Given": 3.75\n },\n {\n "Employee Name": "Shivangi Tomar",\n "Number of Survey Taken": 13,\n "Average Score Given": 4.461538461538462\n },\n {\n "Employee Name": "Shreya Singh",\n "Number of Survey Taken": 7,\n "Average Score Given": 3.857142857142857\n },\n {\n "Employee Name": "Tanvi Gupta",\n "Number of Survey Taken": 1,\n "Average Score Given": 2.0\n },\n {\n "Employee Name": "Vaishali Mahesh Abitkar",\n "Number of Survey Taken": 1,\n "Average Score Given": 4.0\n },\n {\n "Employee Name": "Vinit Bhandari",\n "Number of Survey Taken": 7,\n "Average Score Given": 3.857142857142857\n },\n {\n "Employee Name": "Vipin Vishal Choudhary",\n "Number of Survey Taken": 3,\n "Average Score Given": 4.666666666666667\n },\n {\n "Employee Name": "Yogita Sarup Sharma",\n "Number of Survey Taken": 5,\n "Average Score Given": 2.8\n }\n ]\n}\n```', 'sectionTitle': 'Compliance', 'gridDashBoard': [{'x': 0, 'y': 0, 'cols': 9, 'rows': 4, 'title': 'Location same as reported to RBI and published on website', 'description': 'Display Donut Chart using Compliance: Check whether branch is located on same premise as reported to RBI and published on ABFL website? (Y/N) with Yes and No'}, {'x': 9, 'y': 0, 'cols': 11, 'rows': 4, 'title': 'Regulatory notices and licenses display on notice', 'description': 'Display Donut Chart using Compliance: Check whether all regulatory notices and licenses are displayed on notice board? (Y/N) with Yes and No'}]}]
Leave a Comment