/Python/Space weather dashboard build your own custom dashboard to analyze and predict weather

Space weather dashboard build your own custom dashboard to analyze and predict weather

import ftplib#Open ftp connection
ftp = ftplib.FTP('ftp.seismo.nrcan.gc.ca', 'anonymous',
'user')#List the files in the current directory
print("File List:")
files = ftp.dir()import datetimenow=datetime.datetime.now()
ftp.cwd("intermagnet/minute/provisional/IAGA2002/" + str(now.year) + "/" + str(now.strftime("%m")))
# files = ftp.dir()

Source: analyticsvidhya.com

Space weather dashboard build your own custom dashboard to analyze and predict weather

for line in fileobject:
    row_bytes = line.split()

    date = row_bytes[0].decode("utf-8") + "-" + row_bytes[1].decode("utf-8") + "-" + row_bytes[2].decode("utf-8")    row_txt = [date, row_bytes[4].decode("utf-8"), row_bytes[5].decode("utf-8"), row_bytes[6].decode("utf-8")]    a_series = pd.Series(row_txt, index = df.columns)
    
    query = 'INSERT INTO sunspots (date, sunspot_count, sunspot_sd, sunspot_obs_no) VALUES ("%s", "%s", "%s", "%s")' % (a_series["Date"], a_series["Sunspot_count"], a_series["Sunspot_sd"], a_series["Observ_No"])    cur.execute(query)

Source: analyticsvidhya.com

Space weather dashboard build your own custom dashboard to analyze and predict weather

import sqlite3
conn = sqlite3.connect("space.db", isolation_level=None)
cur = conn.cursor()cur.execute('''
    CREATE TABLE sunspots (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    date DATE,
    sunspot_count INTEGER,
    sunspot_sd REAL,
    sunspot_obs_no INTEGER
    );
    ''')

Source: analyticsvidhya.com

Space weather dashboard build your own custom dashboard to analyze and predict weather

import json
import urlliburl_mag="https://services.swpc.noaa.gov/products/solar-wind/mag-7-day.json"
url_plasma="https://services.swpc.noaa.gov/products/solar-wind/plasma-7-day.json"mag=urllib.request.urlopen(url_mag)
plasma=urllib.request.urlopen(url_plasma)mag_json=json.loads(mag.read())
plasma_json=json.loads(plasma.read())

Source: analyticsvidhya.com

Space weather dashboard build your own custom dashboard to analyze and predict weather

import pandas as pd
import numpy as npdf = pd.DataFrame(columns = ["Date", "Sunspot_count", "Sunspot_sd", "Observ_No"])

Source: analyticsvidhya.com

Similar codes

1 vote304 views1 answer
The month before python dateime
Python
0 vote386 views1 answer
Code suggestion html not working in django-html
Python Django
2 votes302 views1 answer
How to move your cursor using python
Python
5 votes253 views1 answer
Python multi split
Python
4 votes279 views1 answer
Unique values in dataframe column count
Python
0 vote281 views1 answer
Defaultdict count key value pairs
Python
1 vote263 views1 answer
Wonsan
Python
1 vote288 views1 answer
Python groupby sum single columns
Python
2 votes341 views2 answers
Flask 'export' is not recognized as an internal or external command, operable program or batch file.
Python Flask
3 votes291 views3 answers
Convert all columns to float pandas
Python