Code Monkey home page Code Monkey logo

pandas's Introduction

pandas

pandas's People

Contributors

iceboy07 avatar

Watchers

avatar

pandas's Issues

Currency Conversion

Write a python script using requests library that will connect to this API "https://api.exchangeratesapi.io/2019-09-26?base=INR" (please use all the available bases -USD, EUR, etc) and get all the currency conversation rates, it should always get it for the past 90 days (today - 90).
The result should be stored in a jsonline file like as follow:

{"rates":{"CAD":0.0184719572,"HKD":0.1089946555,"ISK":1.7259024347,"PHP":0.7291748266,"DKK":0.0943447004,"HUF":4.2194903155,"CZK":0.3274413433,"GBP":0.0112212718,"RON":0.0598127535,"SEK":0.1351788444,"IDR":196.3023235246,"INR":1.0,"BRL":0.0571177682,"RUB":0.8935790365,"HRK":0.0934590067,"JPY":1.5064373887,"THB":0.4258026204,"CHF":0.0138552314,"EUR":0.0126347177,"MYR":0.0583079586,"BGN":0.0247109808,"TRY":0.079680847,"CNY":0.0988654024,"NOK":0.1247236156,"NZD":0.022017259,"ZAR":0.2056679344,"USD":0.0139310397,"MXN":0.2715440888,"SGD":0.0191731841,"AUD":0.0203696918,"ILS":0.049562207,"KRW":16.5723274413,"PLN":0.0548548903},"base":"INR","date":"2019-09-17"}
{"rates":{"CAD":0.0186069854,"HKD":0.1099432071,"ISK":1.7380919105,"PHP":0.7323745029,"DKK":0.0948746617,"HUF":4.2294840357,"CZK":0.328966928,"GBP":0.0112721867,"RON":0.0601801619,"SEK":0.1363258668,"IDR":197.4566429924,"INR":1.0,"BRL":0.0572312501,"RUB":0.9013238975,"HRK":0.0939941809,"JPY":1.5187975657,"THB":0.42880557,"CHF":0.0139746147,"EUR":0.0127053502,"MYR":0.0587571626,"BGN":0.024849124,"TRY":0.0796155361,"CNY":0.0995451485,"NOK":0.1256622664,"NZD":0.0221428844,"ZAR":0.2052879668,"USD":0.0140432236,"MXN":0.2714231263,"SGD":0.0192892627,"AUD":0.0205178701,"ILS":0.049646156,"KRW":16.7230360705,"PLN":0.0551031039},"base":"INR","date":"2019-09-18"}
{"rates":{"CAD":0.018605535,"HKD":0.1097746838,"ISK":1.7356382271,"PHP":0.732299974,"DKK":0.0946011516,"HUF":4.215827247,"CZK":0.328022956,"GBP":0.0112417415,"RON":0.0601113596,"SEK":0.1358396625,"IDR":197.1304959238,"INR":1.0,"BRL":0.057944979,"RUB":0.8956121292,"HRK":0.0937624709,"JPY":1.5134258585,"THB":0.4279805152,"CHF":0.0138977747,"EUR":0.0126688922,"MYR":0.0587646563,"BGN":0.0247778193,"TRY":0.0798431591,"CNY":0.0994736075,"NOK":0.125301678,"NZD":0.0222161693,"ZAR":0.2056807312,"USD":0.014020663,"MXN":0.2716539872,"SGD":0.0193111923,"AUD":0.0206388922,"ILS":0.0492680548,"KRW":16.7437146459,"PLN":0.0549652556},"base":"INR","date":"2019-09-19"}

Then the jsonline file should be imported into any database of your choice to a table named currency having the following columns - date, base_currency, 'CAD', 'HKD', 'ISK', 'PHP', 'DKK', 'HUF', 'CZK', 'GBP', 'RON', 'SEK', 'IDR', 'INR', 'BRL', 'RUB', 'HRK', 'JPY', 'THB', 'CHF', 'EUR', 'MYR', 'BGN', 'TRY', 'CNY', 'NOK', 'NZD', 'ZAR', 'USD', 'MXN', 'SGD', 'AUD', 'ILS', 'KRW', 'PLN'

Once this two steps are done, use the jsonline file and take base=INR, analyse all the patterns you can find and come up with our own metrics.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.