theredpea

['2014', '2015','2016','2017','2018','2019','2020','2021','2022'].map(year=>{ return ['01','02','03','04', '05','06','07','08','09','10','11','12'].map(month=>[year, month]);}).flat()
    .forEach(async ([year, month])=>{
        let fetch_url = `https://www.mybenefitwallet.com/BW/activities/eStatement?year=${year}&month=${month}`;
        // https://stackoverflow.com/a/24586168/1175496
        await fetch(fetch_url) 
        .then(response => response.blob())
        .then(blob => {
            var url = window.URL.createObjectURL(blob);
            var a = document.createElement('a');
            a.href = url;

theredpea

alert(`Hello Nate! Hope today's Beerfest was a success. So Elizabeth Johnson had signed up for a monthly membership but was double billed for both June and July for a total of $70. Can we reimburse her? Her Venmo account is @E.Johnson-2496. Thanks. Can you verify that she has cancelled her monthly membership? She now would like to pay month to month.`);
// club.spond.com
///=============================
///=============================
///=============================
///=============================
const squid_spond_clubid = "39004B1375F244F4AFECC14513031501"
const fetch_opts = {
    "credentials": "include",
    "mode": "cors",

theredpea

// club.spond.com
///=============================
///=============================
///=============================
///=============================
const squid_spond_clubid = "39004B1375F244F4AFECC14513031501"
const fetch_opts = {
    "credentials": "include",
    "mode": "cors",
};

theredpea

function JSONToCSVConvertor(JSONData, ReportTitle, ShowLabel, appendString) {

    //If JSONData is not an object then JSON.parse will parse the JSON string in an Object
    var arrData = typeof JSONData != 'object' ? JSON.parse(JSONData) : JSONData;
    var CSV = '';
    //This condition will generate the Label/Header
    if (ShowLabel) {
        var row = "";

        //This loop will extract the label from 1st index of on array

theredpea

// https://community.qlik.com/t5/QlikView-App-Development/number-of-17-digits/m-p/511285
/*
Henric_Cronström
Employee 
Henric_Cronström
  Employee 2013-09-12 01:44 PM
Re: number of 17 digits
As Gysbert says, such a large number cannot be displayed as an integer. The 64-bit IEEE float can only show 14 digits. Instead, you should try
*/

theredpea

fake_data_index = pd.MultiIndex.from_product([
[
    'nate',
    'jess'
], pd.date_range('2019-01-01', '2019-12-31')
], names=('who', 'date'))
fake_df = pd.DataFrame({
    'increasing': np.arange(len(fake_data)),
    'random': np.random.rand(len(fake_data))
}, index=fake_data_index)

theredpea

#Create a new field 'datetime', which converts strings to a datetime object
# datetime object will make our x-axis look good, showing appropriate labels like "Feb 2018" etc...
pyber_data_df['datetime'] = pd.to_datetime(pyber_data_df['date'])
# a datetime object *also* allows us to access the date part (2019-01-04) , ignoring the time-of-date part (05:39:20)
#Create another new field 'datedate' to store it
pyber_data_df['datedate'] = pyber_data_df['datetime'].dt.floor('d')

avg_fare_by_type_date = (pyber_data_df
                             #group by multiple fields by passing a list of those fields ; 

theredpea

theredpea

theredpea