Leaders in Pharmaceutical Business Intelligence (LPBI) Group

https://pharmaceuticalintelligence.com/contributors-biographies/research-assistants/srinivas-sriram-research-assistant-i/

Week of 8/12/2021 to 8/24/2021

• Tasks
  • Update the map – Remove Dr. Lal
  • Create an SOP article for how to update the map of India for future reference.
  • Edit the URL color of the LPBI Slide Deck – Final Edit
  • Finish all documentation for the Project
  • Finish all code for the Project
  • Upload all Project materials to DropBox
  • Once Project materials are uploaded to DropBox, get the items we want from Dr. Lev-Ari.
• Milestones Met:
  • We made a final update of the map of India by removing Dr. Lal and sent the final updated map to Dr. Lev-Ari – 2 hours.
  • We created an SOP article for how to update the map of LPBI India for future reference – 10 hours:
    • Created a Word Document and uploaded it to DropBox
    • Created a Post on the Journal and uploaded the SOP Article to that Post. 
  • Edited the URL Color of the LPBI Slide Deck into a brighter color (Yellow) and sent the final updated Slide Deck to Dr. Lev-Ari – 2 hours.
  • Finished everything for the final update – 20 hours.
    • The code will not require any more changes/additions. 
    • We have uploaded our code (as a ZIP File)  to the DropBox Folder as well:
      • Link to the Dropbox Folder: https://www.dropbox.com/sh/2jvimlpr6z4a8kj/AADC7HflF1uO-hvlace9KoUca?dl=0
  • Nearly completed the Documentation – 10 hours.
    • Should be done with some time tonight or tomorrow. 
    • We have created a Microsoft Word Document which we will upload to the same Dropbox folder for everyone to access. 
    • We will also upload each section of the Word Document to the Password Protected Pages on SOP Web-Stat.
    • After that, we will be completed with the Documentation and Code of the Project.
  • Total Hours: 44
• Plan for Next Week:
  • Finish all Documentation and Upload to the Correct Places (Should be done by tonight or tomorrow).
  • Wrap up the Internship:
    • Create the Paragraph for our CV/LinkedIn. 
    • Receive the Certificates from Dr. Lev-Ari
    • Receive the LinkedIn Recommendation from Dr. Lev-Ari.

Week of 8/03/2021 to 8/12/2021

• Tasks
  • Finalize all code and make sure that everything works according to plan.
  • Document all code and outline how everything works in detail. 
  • Once Documentation and Code are finished and completed, upload everything to the DropBox folder.
  • If any opportunities come for code evaluation, then provide our code to them for a review (very beneficial to us). 
  • Add new updates for the LPBI 2.0 Slide Deck and send them to Dr. Lev-Ari when completed.
  • Find a solution for embedding Dr. Lev-Ari’s Tweets for the #WMIF21 that includes all the pictures of the Tweets for the article post. 
  • Create an SOP Article for how to Update the Map.
  • Remove Dr. Lal from the LPBI India Map.
  • Contact WordPress to figure out the issue with Abhisar and Srinivas not being able to access the Statistics through WordPress Jetpack. 
  • Let Dr. Lev-Ari Know of our Future Plans with LPBI.
• Milestones Met
  • Contacted WordPress (With Dr. Lev-Ari’s Help), and got the access we needed to run our program to extract the Views Statistics – 10 hours.
  • Started the Documentation Website for our Project – 10 hours.
    • Will contain full information on how to install, run, and view the data required. 
  • Added section for the “2.0 LPBI is a Very Unique Organization” Website in the LPBI Slideshow – 1 hour.
  • Worked on the Program – 20 hours.
    • Added Progress Bars to show the status of each aspect of the program. 
    • Added email sending functionality that would send the final data output to the person who ran the program. 
    • After retrieving the access, there were some small bugs that we had to fix with the new JetPack Statistics Interface. 
  • Discussed future plans for LPBI with our parents and amongst ourselves – 2 hours.
    • Estimated Time when our Project will be Completed – Friday, August 20th.
      • Completed with Code and Documentation Website. 
    • Once we upload our project to DropBox, we would like the following:
      • Certificate of Completion for the Internship
      • One Paragraph in our CV explaining what we have done. 
      • A recommendation on LinkedIn from Dr. Lev-Ari
      • Having Dr. Lev-Ari as a future reference for any other work we decide to pursue.
      • These things would be very beneficial to us – and would be highly appreciated. 
    • During the School Year, we will not be able to continue the Internship. 
      • Our parents want us to focus on School, and we will not be able to contribute as much as we would like during school time. 
      • We will be able to help LPBI during our School Breaks throughout the year (ex. Winter Break, Spring Break, etc.)
  • Total Hours: 41
• Plan for Next Week:
  • Find a solution for embedding Dr. Lev-Ari’s Tweets for the #WMIF21 that includes all the pictures of the Tweets for the article post. 
  • Update the map – Remove Dr. Lal
  • Create an SOP article for how to update the map of India for future reference.
  • Finish all documentation for the Project
  • Finish all code for the Project
  • Upload all Project materials to DropBox
  • Once Project materials are uploaded to DropBox, get the items we want from Dr. Lev-Ari. 
• Accessed External Resources
  • https://lpbi-views-project.sidepage.co/
    • Documentation Website – Still in Progress.

Week of 7/28/2021 to 8/03/2021

• Tasks
  • Finalize all code and make sure that everything works according to plan.
  • Document all code (Very Important!) and outline how everything works in detail. 
  • Once Documentation and Code are finished and completed, upload everything to the DropBox folder.
  • If any opportunities come for code evaluation, then provide our code to them for a review (very beneficial to us). 
  • Run through all Podcast conversions amongst Ethan, Abhisar, and Srinivas and report our plan(s) to Dr. Lev-Ari
    • Then, convert the articles requested to podcasts. 
  • Add new updates for the LPBI 2.0 Slide Deck and send them to Dr. Lev-Ari when completed.
  • Narrate a podcast of our SOP DropBox Article and embed it onto the website. 
  • Find a solution for embedding Dr. Lev-Ari’s Tweets for the #WMIF21 that includes all the pictures of the Tweets for the article post. 
  • Add Pallavi Kaulwar to the map
  • Remove Pallavi Kaulwar from the map
• Milestones Met
  • Finalize all code and make sure that everything works according to plan.
    • Rewrite the summation algorithm so it is cleaner – 5 hours
    • Clean up the project directory – 2 hours
    • Set up the project to be published as a PyPI Package – 5 hours
    • Find different methods to smoothen out the user experience- 8 hours
      • Use Modin instead of Pandas to increase the speed of Pandas.
      • Use Alive-Progress for progress bars instead of printing out the status of each “worker”
    • Debug the Statistics problem – 10 hours
      • Statistics button on classic view not working and showing any statistics.
      • Debugged different workarounds and solutions
  • Document all code (Very Important!) and outline how everything works in detail.
    • Started the documentation website (created an outline and started filling in some information) – 15 hours.
  • Converted the articles of LPBI’s Founders to Podcasts using SpeechKit (All of the journal articles provided in the Word Document Dr. Lev-Ari sent to us) – 5 hours.
  • Worked a little bit on the updates for the LPBI 2.0. Slide Deck – 2 hours.
    • Need to finish the slides for the “2.0 LPBI is a Very Unique Organization” Post.
  • Created a podcast of our SOP DropBox Article and embedded it onto the website – 2 hours.
  • Updated the map of LPBI India – 5 hours
    • First added Pallavi Kaulwar to the map, but then removed later. 
    • Will add a replacement for Dr. Ghosh when necessary. 
  • Total Hours: 59
• Plan for Next Week:
  • Find a solution for embedding Dr. Lev-Ari’s Tweets for the #WMIF21 that includes all the pictures of the Tweets for the article post. 
  • Update the map when required.
  • Finish the LPBI 2.0. Slide Deck
  • Contact WordPress to figure out the issue with Abhisar and Srinivas not being able to access the Statistics through WordPress Jetpack. 
  • Finish all documentation for the Project
  • Finish all code for the Project
  • Upload all Project materials to DropBox
• Accessed External Resources
  • Modin – https://modin.readthedocs.io/en/latest/index.html
  • Alive-Progress – https://github.com/rsalmei/alive-progress

Week of 7/22/2021 to 7/27/2021 

• Tasks:
  • Finish LPBI 2.0 Official Slide Deck
  • Update the map of LPBI India.
  • Reconvert the Podcasts for our first posts using LPBI’s Official Login.
  • Divide the work amongst Abhisar, Ethan, and Srinivas for converting LPBI’s Group Founder articles into Podcasts and embed these podcasts into the correct URLs and pages.
  • Finish presentation for LPBI Internal Meeting on Wednesday, July 22nd. 
  • Reorganize the code for the Summation algorithm and make it more efficient.
  • Clean up all code and make sure that it is neat and implementable. 
  • Rigorously test our code to make sure that it works properly in all types of environments. 
  • Narrate a podcast of our SOP DropBox Article and embed it onto the website. 
  • Insert our MS Word version of the SOP DropBox Article into the correct Dropbox folder.
  • Find a solution for embedding Dr. Lev-Ari’s Tweets for the #WMIF21 that includes all the pictures of the Tweets for the article post. 
• Milestones Met:
  • Finished a new update for LPBI 2.0 Official Slide Deck – 5 hours.
    • Still need to implement Dr. Lev-Ari’s Comments sent today at 3 o’clock. 
  • Updated the map of LPBI India – 3 hours.
    • Still need to add Ms. Pallavi Kaulwar to the slideshow. 
  • Reconverted our Podcasts using the official LPBI login for Anchor – 3 hours.
    • Deleted our old content on Personal Accounts, then redid everything on the official account.
  • Finished the presentation for LPBI Internal Meeting on Wednesday, July 22nd – 7 hours. 
    • Presented live to LPBI Internal USA Members on this day explaining all necessary content, including:
      • The goal of the project
      • How we accomplished the criteria set for this project – Our Journey (First used WordPress Statistics Page, then tried going through each article individually, and finally using the Threads to get the desired result). 
      • A live demonstration/walkthrough of the code structure and how it works. 
      • How our project will benefit LPBI in the future (ex. Blockchain usage and calculating profits). 
      • Conclusions that were drawn from our project
    • Got new, important ideas for how we can improve our project to further expand on the needs of LPBI.
  • Inserted our MS Word version of the SOP DropBox Article into the correct Dropbox folder (Did not take much time).
  • Reorganized some parts of our algorithm – 22 hours.
    • Found some last-minute bugs with some of the data, so we fixed them. 
    • Worked a lot on the Summation part of our Project by testing it with more date ranges and made the code a lot shorter, faster and easier to understand. 
    • Now, just need to add some final edits and our program will be ready for deployment. 
  • Total Hours: 40
• Plan for Next Week:
  • Finalize all code and make sure that everything works according to plan. 
  • Document all code (Very Important!) and outline how everything works in detail. 
  • Once Documentation and Code are finished and completed, upload everything to the DropBox folder.
  • If any opportunities come for code evaluation, then provide our code to them for a review (very beneficial to us). 
  • Run through all Podcast conversions amongst Ethan, Abhisar, and Srinivas and report our plan(s) to Dr. Lev-Ari
    • Then, convert the articles requested to podcasts. 
  • Add new updates for the LPBI 2.0 Slide Deck and Send to Dr. Lev-Ari when completed.
  • Narrate a podcast of our SOP DropBox Article and embed it onto the website. 
  • Find a solution for embedding Dr. Lev-Ari’s Tweets for the #WMIF21 that includes all the pictures of the Tweets for the article post. 
• Accessed External Resources:
  • Used Anchor to delete our old content (on Personal Accounts), and to recreate the Podcasts with LPBI’s Official Login. 
  • Used ZeeMaps and Google Slides to edit the map for LPBI India with the necessary changes.

Week of 7/15/2021 to 7/21/2021

• Tasks
  • Create/Finish LPBI’s Official 2.0 Slide Deck
  • Make the map of LPBI India (Table given by Mrs. Kaur)
  • Update Dr. Kandala’s CV on LPBI’s Website
  • Update Dr. Ghosh’s CV on LPBI’s Website
  • Convert both of our first posts on LPBI’s Website into Podcasts using Anchor and embed them on the website
  • Divide the work amongst Abhisar, Ethan, and Srinivas for converting LPBI’s Group Founder articles into Podcasts and embed these podcasts into the correct URLs and pages.
  • Finish our project’s program:
    • Figure out whether Threading or MultiProcessing works better for the extraction of articles into JSON format in quick time. 
    • Sum the data accordingly into the proper format desired for this project
    • Rigorously test the code with different starting and ending dates to make sure that it works
    • Clean up the code, organize it, and make it readable and easily deployable.
  • Finish the presentation of our project for tomorrow’s presentation:
    • It is going to be a PowerPoint Presentation that will contain:
      • The goal of the project
      • How we accomplished the criteria set for this project – Our Journey (First used WordPress Statistics Page, then tried going through each article individually, and finally using the Threads to get the desired result). 
      • A live demonstration/walkthrough of the code structure and how it works. 
      • How our project will benefit LPBI in the future (ex. Blockchain usage and calculating profits). 
      • Conclusions that were drawn from our project
• Milestones Met
  • Created multiple drafts of LPBI’s Slideshow and sent them to Dr. Lev-Ari for review (currently working on another draft) (Slideshow is currently 99 slides long) – 15 hours. 
  • Made the map of LPBI India that was used for the launch of LPBI India on Monday, July 19th – 3 hours.
  • Updated Dr. Kandala’s CV on LPBI’s Website – 1 hour.
  • Updated Dr. Ghosh’s CV on LPBI’s Website – 1 hour.
  • Converted both of our posts into podcasts and embedded them onto the pages using Anchor and Spotify – 5 hours.
  • Created a working draft of our final program – 25 hours
    • Tried the Multithreading Method, but the Threads kept breaking and not working to our request – 10 hours.
    • Finished the MultiProcess extraction of the articles into the JSON format in an efficient manner that takes ~20 minutes to complete the full extraction with the ideal processes working – 10 hours. Tested
    • We have created a summation algorithm that takes in the requested dates for the summation and cleanly displays the output in the correct format in an Excel or a CSV file – 5 hours. Need to Test More
      • Can either work for multiple years at a time or can sum up months at a time.
  • Created a Draft of our Presentation – 3 hours. 
    • Will contain all the parts listed above in the “Tasks” Category. 
    • Will be presented fully in the 20-minute allocated time span. 
  • Total Hours Spent: 53 hours
• Plan for Next Week:
  • Organize, clean up, and rigorously test our code to make sure it works in all sorts of environments. 
  • Run through a final run of our program and give the final output(s) of the task to Dr. Lev-Ari
  • Document the code thoroughly and make sure any new intern can read our code and understand it quickly.
  • Once the entire Project has been verified, tested, documented, and presented, send project resources to Dr. Lev-Ari.
  • Finish the LPBI 2.0 Slide Deck with the New Suggestions for the Draft. 
  • Finish the entire presentation for tomorrow and practice it amongst ourselves to make sure that it is good. 
  • Present tomorrow in the Internal Meeting at 2:15. 
  • Run through all Podcast conversions amongst Ethan, Abhisar, and Srinivas and report our plan(s) to Dr. Lev-Ari
    • Then, convert the articles requested to podcasts. 
• Accessed External Resources:
  • Used Anchor Platform and Ethan’s Tutorial to convert our articles into Podcasts.
  • Created the map from ZeeMaps and formatted using Google Slides.

Week of 7/7/2021 to 7/14/2021:

• Tasks
  • Create official LPBI 2.0 Slide Deck
  • Create Standard Operating Procedures Manual for how to get an email on DropBox on the Journal and in an MS Word File (for the use of later LPBI Interns and Members)
  • Once Mrs. Kaur gives us a table of the locations of all LPBI India Members, make a Map for Dr. Lev-Ari’s Presentation (In JPG format). 
  • Update Dr. Lal’s CV on LPBI’s Website
  • LPBI New Website Plugins – Look at 3rd Party Plugins and see if they would help us in our Project (Recommended by Dr. Hanoch Lev-Ari)
  • Work on our code and make it as fast as possible while also providing the data in the necessary format. 
  • Find the best method to retrieve the desired solution for our project. 
  • Once Ethan provides us with the SOP for Audio Conversion of an Article, apply the necessary Audio Conversion for the designated articles. 
• Milestones Met:
  • We created a Standard Operating Procedures Manual for how to get an email on DropBox on the Journal and in an MS Word File (for the use of later LPBI Interns and Members) – 2 hours. 
    • Link of the Journal Article: https://pharmaceuticalintelligence.com/2021/07/14/procedure-for-creating-a-dropbox-account/
  • We met with Alex Crystal, who gave his suggestions of our code at the current moment and what he did to solve the project in the past – 30 mins.
  • Began work on Presentation, but still need to finish the entirety of it (Once we are done, we will send it to Dr. Lev-Ari for feedback and suggestions) – 2 hours.
  • Reviewed Google Analytics – 1 hour. 
  • Updated Dr. Lal’s CV on LPBI’s Journal (Formatting original CV into an MS Word File, and then copying it into the Journal) – 2 hours. 
  • Perfected old code that would take Top 500 articles for any given time period and display in a new format (May be of use to LPBI later on) – 7 hours
  • Made a completely new program that gets all of the necessary data – 27 hours:
    • Goes through each of the article’s view data and adds it to a JSON file that contains the view table for each of the articles. 
    • Currently working on adding CPU Threading to make the program more efficient and taking less time (Before: Took a long time because there is a huge database of articles and went through each one individually). 
  • Final Decision from us: We would like to stick with our program for this project, as we have more control of the output (more tailored to LPBI’s needs), and it is easier to change. 
  • Total Hours Spent: 41 hours 30 minutes.
• Plan for Next Week:
  • Perfect the new program (Make sure that it provides the exact output needed, and code is easy to understand and implement). 
  • Create the Documentation once the code is done
  • Finish LPBI 2.0 Slide Deck for Dr. Lev-Ari.
  • Make the map of LPBI India once Mrs. Kaur provides us with the table. 
  • Prepare our presentation of our Project #1 at the LPBI Meeting on July 21st.  
  • Once Ethan provides us with the SOP for Audio Conversion of an Article, apply the necessary Audio Conversion for the designated articles. 
• Accessed External Resources:
  • Google Analytics – Saw the documentation. 

Week of 7/1/2021 to 7/6/2021

• Tasks
  • Update the website statistics for July 1st on https://pharmaceuticalintelligence.com/2021/02/01/february-1-2021-we-celebrate-1924400-e-readers-6000-scientific-journal-articles-7525-scientific-comments-a-journal-ontology-of-728-medical-life-sciences-research-categories-10440-tag/
  • Continue working on Project #1. 
    • Make code more efficient
    • Discuss and figure out how to overcome the barrier of only ~500 articles being displayed for the statistics
• Milestones Met
  • Updated the website statistics for July 1st on the webpage (Includes showing side-by-side comparisons of views for specific fields and graphs for visual comparison) – 16 hours. 
  • Updated the code for Project #1 – More organized, algorithms are more complex, and now runs smoothly with the given data – 20 hours.
  • Discussed and Researched Methods of how to overcome the barrier of 500 articles – 4 hours.
    • Email Thread with one of the Staff Members trying to get an answer. 
    • One potential method is accessing each article’s stats page and extracting the necessary data from a time interval. 
  • Total Hours: 40
• Plan for Next Week
  • Rigorously test the code in various testing environments and check for any bugs in the program. Make sure the code is compatible with all three operating systems and make necessary changes if needed. Add failsafe to parts of the program to ensure the code does not error out.
  • Try to get WordPress staff on a live meeting to solve the problem of not being able to see all 6,050 articles and their views on the stats page.
  • Once a proper method for getting all of the article statistics is accomplished, implement the newly developed algorithm in our program. 
  • Document all code, project files, and folders to make sure that any person who wants to understand and use our code is able to do so with ease. 
  • Prepare for Presentation to LPBI on July 21st, 2021.
• Accessed External Resources
  • WordPress Documentation

Week of 6/22/2021 to 6/29/2021

• Tasks
  • Finish all On-Boarding Tasks assigned by Dr. Lev-Ari 
  • Start Working on Project #1. 
• Milestones Met
  • Completed all On-Boarding assignments (Includes posting one article to LPBI and completing all 6 requirements for Summer Interns at LPBI) – 10 hours. 
  • Started Working on the code required for the First Project – Can do the following: 
    • Get all the needed data from LPBI’s Site automatically – 10 hours
    • Format the data so that it can be presented by the total views each article got within each timespan – 15 hours
    • Can be formatted by views by year if the time exceeds one year. 
    • Otherwise, will display only the views each article got within a particular timespan. 
  • We talked with the WordPress staff through the forums and researched online to figure out how to gather the views for all 6,000+ articles – 5 hours
  • Total Hours: 40
• Plan for Next Week
  • Finish up all final touches to the code – make sure it is perfect.
  • WordPress staff said that the website statistics page can only display a maximum of 500 articles at any given point in time – which is why our data does not have all 6,500 articles. We need to figure out a method for how to get all the statistics for each of the 6,500 articles at any time. Once we get this proper data, we can easily input it into our new code and get the proper data.
  • After all the code and data outputs are complete and approved by Dr. Lev-Ari, we will work on documenting our code in the most effective way possible (Including detailed comments and docstrings in our code, and making detailed documentation that shows how to navigate and use our code).
  • Update all stats on one of the web pages with July 1st’s Data.
• Accessed External Resources
  • WordPress Forum Link: https://wordpress.com/forums/topic/cannot-access-all-of-the-view-data-for-every-post/#post-3698148
  • This is where we were in contact with the WordPress staff to ask our questions.