umarhussain88

        <!-- NAVBAR -->
  <nav class="navbar navbar-main navbar-expand-md navbar-default nav-V2 navbar-scrollUp navbar-fixed" role="navigation">
    <div class="container">
   <!-- Collect the nav links, forms, and other content for toggling -->
   <div class="collapse navbar-collapse navbar-ex1-collapse">
    <ul class="nav navbar-nav ml-auto">
      <li class="nav-item">
        <a href="{{ url_for('home') }}" class="nav-link" role="button" aria-expanded="false">Home</a>
        </ul>
      </li>

umarhussain88

WITH cte_keys AS (
SELECT  obj.name AS FK_NAME,
    sch.name AS [schema_name],
    tab1.name AS [table],
    col1.name AS [column],
    tab2.name AS [referenced_table],
    col2.name AS [referenced_column]
FROM sys.foreign_key_columns fkc
INNER JOIN sys.objects obj

umarhussain88

def generate_new_keys(*args,key='Carid',name='Carname'):
    """
    Takes in a number of dataframes and returns any duplicates with a new unique id. 
    groupby columns fixed to CarID and CarName.
    """
    # adds dictionaries into a single list.
    dicts_ = [arg.groupby(key)[name].first().to_dict() for arg in args]
    
    #merges dicts on unique key, this will exclude duplicates.
    merged_dicts = dict(ChainMap(*dicts_))

umarhussain88

import pandas as pd

rows = [{'dt' : '2020-01-01 12:00:00'}, 
        {'dt' : '2020-01-04 13:00:00'}, 
        {'dt' : '2020-01-08 14:00:00'}, 
        {'dt' : '2020-01-09 15:00:00'}]

dt = pd.DataFrame(rows)
dt['dt'] = pd.to_datetime(dt['dt'],format='%Y-%m-%d')

umarhussain88

from .models import Carbon 
from django.db.models import Q 
from django.views.generic import ListView
from datetime import datetime 



class CarbonDataView(ListView):
    model = Carbon 
    context_object_name = 'carbon'

umarhussain88

from django.db import models



class Carbon(models.Model):

    id = models.AutoField(
        primary_key=True,
        editable=False,
        

umarhussain88

{% extends '_base.html' %}
{% load crispy_forms_tags %}

    {% block javascript %}
    <!--Chart js-->
    <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.min.js" integrity="sha256-Uv9BNBucvCPipKQ2NS9wYpJmi8DTOEfTA/nH2aoJALw=" crossorigin="anonymous"></script>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.min.css" integrity="sha256-aa0xaJgmK/X74WM224KMQeNQC2xYKwlAt08oZqjeF0E=" crossorigin="anonymous" />
    <!-- jQuery -->
    <script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
    {% endblock javascript %}

umarhussain88

df = pd.read_csv('GlobalLandTemperaturesByCountry.csv')
df = df.dropna(subset=['AverageTemperature'])
df['dt'] = pd.to_datetime(df['dt'])
df = df[df['dt'].dt.year >= 1900]
df = df.drop(['AverageTemperatureUncertainty'], axis=1)
df_group = df.groupby(dfRead['dt'].dt.year)['AverageTemperature'].mean().reset_index() 

umarhussain88

CREATE PROCEDURE [stg_ecp].[p_InsertDwFactProductPrices]
	@jobKey	int
AS
BEGIN

	/* ==================================================================================================================
	Description:	Create Fact Table for Products.
	================================================================================================================== */

    SET NOCOUNT ON						-- Eliminate any dataset counts

umarhussain88

import requests
import json
import base64
import pprint
import unittest
import time
import datetime

# Put this in contactMechList
ADDRESS_TEMPLATE = {