View the step-by-step solution to:


This question was created from Pandas assignment.docx


further answer from question 1


Finally, load the Sciamgo Journal and Country Rank data for Energy Engineering and Power
Technology from the file scimagojr -3. x1sx, which ranks countries based on their journal
contributions in the aforementioned area. Call this DataFrame ScimEn.
Join the three datasets: GDP, Energy, and ScimEn into a new dataset (using the intersection of
country names). Use only the last 10 years (2006-2015) of GDP data and only the top 15 countries
by Scimagojr 'Rank' (Rank 1 through 15).
The index of this DataFrame should be the name of the country, and the columns should be ['Rank',
"Documents', 'Citable documents', 'Citations', 'Self-citations', 'Citations per document', 'H index',
"Energy Supply', 'Energy Supply per Capita', '% Renewable', '2006', '2007', '2008', '2009', '2010',
'2011', '2012', '2013', '2014', '2015'].

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Python Programming tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors